In PLSQL, How to fetch "User Tables" but not limited to Owner wise only, that have been created under different Schemas of different Users

30 views Asked by At

I want to fetch the list of tables against each user and owner of different schemas.

I tried this...

Select Owner, Object_Type from all_objects where Object_Type = "Table";

&

Select Owner, Table_Name from all_tables;

But I wanted tables user wise under its Owner.

0

There are 0 answers