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!

substr and instr for long column

user8929623Jan 19 2010 — edited Jan 19 2010

Plesae need support ,how can use instr and substr function for column with long datatype

select substr(rec,1,(instr(rec,'?',1))) from F_DE_O_HISTORY_QUEUE_PRE_TST2

rec column is long,When execute this select message displayed as ORA-00932: inconsistent datatypes: expected NUMBER got LONG

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 16 2010

Added on Jan 19 2010

5 comments

13,887 views