convert clob to varchar2

Posted by Shamik on Stack Overflow See other posts from Stack Overflow or by Shamik
Published on 2010-04-23T19:31:02Z Indexed on 2010/04/23 19:33 UTC
Read the original article Hit count: 615

Filed under:
|

I have a Oracle table whose column is a CLOB datatype. I want to read the content of this table as a text.

I tried select dbms_lob.substr( sqltext, 4000, 1 ) from test but this one selects only the first 4000 bytes. How to read the entire content ? there are more than 4000 characters in the sqltext column. Please advise.

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about sql