Cov txheej txheem:

Kuv yuav tso saib BLOB cov ntaub ntawv hauv SQL Developer li cas?
Kuv yuav tso saib BLOB cov ntaub ntawv hauv SQL Developer li cas?

Video: Kuv yuav tso saib BLOB cov ntaub ntawv hauv SQL Developer li cas?

Video: Kuv yuav tso saib BLOB cov ntaub ntawv hauv SQL Developer li cas?
Video: Ua siab hnov qab kuv mus by zuag lauj & pov vwj nkauj tawm tshiab 2020 2024, Hlis ntuj nqeg
Anonim

1 Teb

  1. Qhib cov ntaub ntawv qhov rais ntawm koj lub rooj.
  2. Cov BLOB cell yuav muaj npe li ( BLOB ).
  3. Txoj nyem rau ntawm tes.
  4. Koj yuav pom ib tug cwj mem icon.
  5. Nws yuav qhib ib blob qhov rais editor.
  6. Koj yuav pom ob lub thawv kos tawm tsam qhov kev xaiv Saib raws li: Duab lossis Ntawv.
  7. Xaiv lub thawv uas tsim nyog.

Tom qab ntawd, BLOB cov ntaub ntawv zoo li cas?

A BLOB (binary loj khoom) yog ib tug sib txawv-ntev binary hlua uas muaj peev xwm mus txog 2, 147, 483, 647 cim ntev. Zoo li Lwm hom binary, BLOB cov hlua tsis cuam tshuam nrog nplooj ntawv code. Ntxiv rau, BLOB hlua ua tsis tuav tus cwj pwm cov ntaub ntawv.

BLOB cov ntaub ntawv hom hauv Oracle yog dab tsi? A BLOB (Binary Loj Object) yog ib qho Oracle cov ntaub ntawv hom uas tuaj yeem tuav txog 4 GB ntawm cov ntaub ntawv . BLOB's yog ke rau khaws cov ntaub ntawv digitized (piv txwv li, duab, suab, video).

Ib sab ntawm no, kuv yuav saib BLOB cov ntaub ntawv hauv Toad li cas?

Hauv Toad rau Oracle, nyem rau ntawm cov ntawv qhia zaub mov Database> Schema Browser. Tom qab ntawd hauv Tables tab, nrhiav koj lub rooj uas muaj BLOB data thiab nyem rau ntawm nws xaiv. Nyob rau sab xis, nyem rau ntawm Cov ntaub ntawv tab, thiab nws yuav ua yeeb yam koj uas twb muaj lawm cov ntaub ntawv . Tom qab ntawd ua txoj cai nyem rau ntawm qhov cov ntaub ntawv daim phiaj thiab xaiv Export Blobs kev xaiv.

Kuv yuav ua li cas khiav ib. SQL cov ntaub ntawv hauv SQL Developer?

sql ua as a tsab ntawv hauv SQL Developer daim ntawv ua haujlwm. Los yog siv lub Khiav Script icon, lossis tsuas yog nias F5. Piv txwv li, @path tsab ntawv.

  1. Nyem thiab luag koj. sql cov ntaub ntawv dhau mus rau Oracle SQL Developer.
  2. Cov ntsiab lus yuav tshwm sim hauv "SQL Worksheet"
  3. Nyem "Run Script" khawm, lossis ntaus F5, khiav.

Pom zoo: