Dudes:
Let's assume that you don't have access to DBA_TABLES but you need to find all the tables in a schema that have IMG in thier name.
What would the query need to be?
How can you list all tables in a schema?
Thanks - rev
Printable View
Dudes:
Let's assume that you don't have access to DBA_TABLES but you need to find all the tables in a schema that have IMG in thier name.
What would the query need to be?
How can you list all tables in a schema?
Thanks - rev
Connect with this user and select from user_tables
Cheers
Angel
Have you tried selecting from ALL_TABLES table?