LOBs load & extract

From: Andrey Bronfin <bronfin_at_VisualTop.com>
Date: Tue, 28 Nov 2000 11:37:53 +0200
Message-Id: <10504.106165@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_019A_01C0592F.A4E8A960 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear DBAs !
Would U please help me with the following : =20

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 ?
What is the best way to store , load & unload an XML doc in = Oracle8i ?
How can i extract the contents of a LOB column from an Oracle table = to a flat file ?

Many thanks in advance .
Have a nice day .
=20

------=_NextPart_000_019A_01C0592F.A4E8A960 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Dear DBAs !</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Would U please help me with the =
following=20
:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> </FONT></DIV>
<DIV><FONT face=3DArial size=3D2> 1)  As far as i know the =
only way to=20
populate a LOB column in an Oracle table is to load the LOB from a flat = file=20
using SQL*Loader .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>      Is there =

another  way to do it ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>      If  =
i have a=20
variable of LOB datatype in Java , can i insert it directly to a table = without=20
dumping it to a flat file an SQLloading it ?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2> 2)  What is the best =
way to store ,=20
load & unload an XML doc  in  Oracle8i ?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2> 3)  How can i =
extract the contents=20
of a LOB column from an Oracle table to a flat file ?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Many thanks in advance .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Have a nice day .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> </FONT></DIV></BODY></HTML>
Received on Tue Nov 28 2000 - 03:37:53 CST