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 long to varchar

443920May 16 2005 — edited Aug 26 2005

How to convert long to varchar2 in select statement.Example:
Table emp contain xyz column with long datatype.
emp.xyz="abcd2344dfefghsi"
I want to search in emp.xyz table 'abc' string position.

select instr(xyz,'abc') FROM emp
it throws error message as :
ORA-00932: inconsistent datatypes: expected NUMBER got LONG

Kindly anybody can help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 23 2005

Added on May 16 2005

7 comments

8,839 views