In Oracle, how can I get the views defined using a particular table
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Dear All, I tried to get the views that are defined using a particular table name. Can any one give me the query for that? I already tried with user_views in the following way. select view_name from user_views where text like '%tablename%'; The problem here is that the text column datatype is LONG. So I am getting inconsistent datatype err. Thanks Surendran