From: <amerar_at_iwc.net>
Date: Thu, 13 Mar 2008 10:42:50 -0700 (PDT)
Message-ID: <c741d7ce-4ae6-4250-a3db-4bda811ec64d@v3g2000hsc.googlegroups.com>


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

Original text of this message