Re: Converting a CLOB to a String

Check out the DBMS_LOB package. eg.
select DBMS_LOB.SUBSTR(clob_field,1,DBMS_LOB.GETLENGTH(clob_field)) from some_table ...

Be careful about the length of the substring you return. 4000 characters is the limit from SQL*PLUS, or 32,000 (or is it 64,000) in PL/SQL. Dave

jpalloz_at_my-deja.com wrote:

> Inside of a select statement does anyone know how to convert a CLOB
> field to a string E.G:
>
> select some_conversion_function(clob_field) from some_table where
> some_field = 'some_value';
>
> Thanks,
>
> John P.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
  Received on Mon Oct 30 2000 - 20:36:33 CST