Oracle da dosyadan metin yukleme

Example 10-18 Loading LOB DATA with One LOB per LOBFILE

Control File Contents

LOAD DATA
INFILE 'sample.dat'
  INTO TABLE person_table
  FIELDS TERMINATED BY ','
  (name      CHAR(20),
1  ext_fname    FILLER CHAR(40),
2  "RESUME"     LOBFILE(ext_fname) TERMINATED BY EOF)

Datafile (sample.dat)

Johny Quest,jqresume.txt,
Speed Racer,'/private/sracer/srresume.txt',

Secondary Datafile (jqresume.txt)

Johny Quest
        500 Oracle Parkway
           ...

Secondary Datafile (srresume.txt)

Speed Racer
    400 Oracle Parkway
       ...


http://students.kiv.zcu.cz/doc/oracle/appdev.102/b14259/xdb25loa.htm

Burada da XML yukleme ile ilgili ornek var.