How to use pointer files with multiple columns when loading xml data
Posted on 2011-09-02
I have a bunch of different files in a folder.
say 1.xml, 2.xml, 3.xml
I have created a file called clob_pointer.xml which has the following contents:
and i am trying to generate a definition for an external table that will allow me to read the second column.
The following is what i have that doesnt work.
CREATE TABLE ext_clob_table (text CLOB, thedate varchar2(300))
DEFAULT DIRECTORY mytestdir
(FIELDS TERMINATED BY ','
COLUMN transforms (text from lobfile (clob_pointer) from (mytestdir) CLOB)