Date: Thu, 13 Mar 2008 10:42:50 -0700 (PDT)
I've been reading some examples on DBMS_LOB.
We have a table with a CLOB column which contains a lot of text, with new lines and all.
When I run a command like: Select dbms_lob.substr(email_text,1,10) from email_test;
It gives me like, only 1 character, which is not even the first character of the string??
I'm still looking for examples, maybe someone can help?
Thanks! Received on Thu Mar 13 2008 - 12:42:50 CDT