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.

LONG datatype using LIKE operator

MADHAN KUMAR KMar 30 2016 — edited Mar 30 2016

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 27 2016

Added on Mar 30 2016

12 comments

7,332 views