Message-Id: <10504.106165@fatcity.com> From: "Andrey Bronfin" Date: Tue, 28 Nov 2000 11:37:53 +0200 Subject: LOBs load & extract 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 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 ? 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

Dear DBAs !

Would U please help me with the = following=20 :

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 .

Is there = another way to do it ?

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 ?

2) What is the best = way to store ,=20 load & unload an XML doc in Oracle8i ?

3) How can i = extract the contents=20 of a LOB column from an Oracle table to a flat file ?

Many thanks in advance .

Have a nice day .