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
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