Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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