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!

Convert the content of a 'LONG' column to a string

251955Apr 5 2002
One of columns of the table is defined as 'LONG'. It may not be a good idea to define it as 'LONG' but that's another story. Now the 'LONG' column holds some text string. I need to do a substring on this column, but I got a incompatible datatype error. So I'm thinking to convert 'LONG' to a string first, then do substring. How am I going to do it? Shed some light please. THanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2002
Added on Apr 5 2002
1 comment
1,035 views