Re: 'substring' a LONG column

>Does anyone know how to 'substring' a LONG field? We need to obtain the
>first 80 characters and the substring function won't work. Changing this
>column to a LOB datatype on the database is not an option at this time.
>
>Thanks in advance.
>
>-Richelle Hutchinson

Hello Richelle,
please look at, restricions on LONG:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/sql_elem.htm#45443 you cannot use LONG datatype with function substring(), means not directly in SQL.

Also take a look at a very helpful URL, use dbms_sql package to solve your problem:
http://asktom.oracle.com/pls/ask/f?p=4950:8:134596::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:665224430110,%7Blong%7D

...Have a nice day
Manuela Mueller Received on Wed Sep 19 2001 - 22:37:03 CEST