Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Query on LONG datatype using LIKE operator

skvMar 26 2014 — edited Mar 27 2014

I want to search in USER_VIEWS dictionary table for a column that is used in any views or not.  Below is my query.

SELECT view_name, text
FROM user_views
WHERE LOWER (text) LIKE '%<column name>%';

I am getting below error, because TEXT is LONG datatype column in the table.


ORA-00932: inconsistent datatypes: expected NUMBER got LONG


I am working on Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit.  Please help me how to search for column.

Thanks a lot for the help.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 24 2014
Added on Mar 26 2014
9 comments
80,744 views