Prev: Requirement: urgent direct client.
Next: oracle on windows
From: Norbert Pürringer on 18 Apr 2008 05:16
Hello,

I would like to fill a CLOB column in an Oracle table by using a
simple script. Each CLOB value contains a big string. What would be
the best way to insert a CLOB value by a simple INSERT statement?

Thank you,
Norbert
From: DA Morgan on 18 Apr 2008 12:18
Norbert P�rringer wrote:
> Hello,
>
> I would like to fill a CLOB column in an Oracle table by using a
> simple script. Each CLOB value contains a big string. What would be
> the best way to insert a CLOB value by a simple INSERT statement?
>
> Thank you,
> Norbert

Go to: http://www.psoug.org/reference/dbms_lob.html
and look at the DBMS_LOB.APPEND procedure demo.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan(a)x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
 | 
Pages: 1
Prev: Requirement: urgent direct client.
Next: oracle on windows