Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Length of a LONG value

571956Aug 11 2009 — edited Aug 12 2009
What is the easiest way to determine the length of the value in a given LONG column? I am working on converting some tables in my database that still use the LONG column to be CLOB or VARCHAR2...haven't decided yet.

I've found a function that converts it to VARCHAR2 and returns that value. But VARCHAR2 only goes up to 32767, so I'd like to know if the value in the LONG column is larger than that, but the LENGTH() function doesn't work.

Thanks for anyone's help,
ivalum21
This post has been answered by MichaelS on Aug 12 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2009
Added on Aug 11 2009
23 comments
3,340 views