List All Tables in Oracle:
1. Viewing Tables Owned by Current user
select table_name,owner
from user_tables
order by owner,table_name;
2. Viewing Tables Accessible by Current User
select table_name,owner
from all_tables
order by owner,table_name;
3. Viewing All Tables
select table_name,owner
from dba_tables
where owner='schema_name'
order by owner,table_name;
1. Viewing Tables Owned by Current user
select table_name,owner
from user_tables
order by owner,table_name;
2. Viewing Tables Accessible by Current User
select table_name,owner
from all_tables
order by owner,table_name;
3. Viewing All Tables
select table_name,owner
from dba_tables
where owner='schema_name'
order by owner,table_name;
No comments:
Post a Comment