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.

Postgresql XML alani

Create table test
(y int, data xml);

insert into test values (1, 'ffr');

select xpath ('/foo/text()', data) from test;
xpath
-------
{ffr}
(1 row)

Metin arama destegi

Ornek bir sorgu:

select 'a fat cat'::tsvector @@ 'cat'::tsquery;

Diger sorgu sekilleri icin kaynaklar:

1. http://www.postgresql.org/docs/8.3/static/functions-textsearch.html
2. http://www.postgresql.org/docs/8.3/static/ddl-schemas.html