On Sun, May 21, 2000 at 01:46:02AM -0800, Andrey Bronfin wrote:
> Dear DBAs !
> Would U please help me with the following :
>
> 1) As far as i know the only way to populate a LOB column in an Oracle table is to load the LOB from a flat file using SQL*Loader .
> Is there another way to do it ?
> If i have a variable of LOB datatype in Java , can i insert it directly to a table without dumping it to a flat file an SQLloading it ?
>
> 2) What is the best way to store , load & unload an XML doc in Oracle8i ?
>
> 3) How can i extract the contents of a LOB column from an Oracle table to a flat file ?
Take a look at the DBMS_LOB packages. You can read and write files
with the UTL_FILE package.
Received on Sun May 21 2000 - 04:40:16 CDT
