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

From: DA Morgan <>
Date: Fri, 18 Apr 2008 09:18:49 -0700
Message-ID: <>

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: and look at the DBMS_LOB.APPEND procedure demo.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Apr 18 2008 - 11:18:49 CDT

Original text of this message