Unload SQL Table data having CLOM Column
I have to unload a table into flat file .This table which is to be unloaded has a CLOB column.
Once unloaded into flat file-This flat file will be used to load data into another table having almost similar columns.
I did develop script like spooling this into a txt file :
where oid between 200 and 220
But when I use SQWL Loader to load data into another table having clob column it does not work.
I would appreciate if you could let me know, if there is another by which it could be done.
Thanks for all the help.
Re: Unload SQL Table data having CLOM Column
Have you looked at the DBMS_LOB package?
You should be able to use that package to parse the LOBS.