Re: How to fill a CLOB field with a simple script

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_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org