LOBS
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>
Date: Thu, 13 Mar 2008 10:42:50 -0700 (PDT)
Message-ID: <c741d7ce-4ae6-4250-a3db-4bda811ec64d@v3g2000hsc.googlegroups.com>
Hi,
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