How To List All Tables in Your Schema?
SQL tutorial | Interview questions | Oracle :: Interview questions :: Oracle DBA Interview questions
Page 1 of 1
How To List All Tables in Your Schema?
If you log in with your Oracle account, and you want to get a list of all tables in your schema, you
can get it through the USER_TABLES view with a SELECT statement, as shown in the following
SQL script:
SQL> connect HR/fyicenter
Connected.
SQL> SELECT table_name, status, num_rows FROM USER_TABLES;
TABLE_NAME STATUS NUM_ROWS
------------------------------ -------- ----------
REGIONS VALID 4
LOCATIONS VALID 23
DEPARTMENTS VALID 27
JOBS VALID 19
EMPLOYEES VALID 107
JOB_HISTORY VALID 10
COUNTRIES VALID 25
7 rows selected.
can get it through the USER_TABLES view with a SELECT statement, as shown in the following
SQL script:
SQL> connect HR/fyicenter
Connected.
SQL> SELECT table_name, status, num_rows FROM USER_TABLES;
TABLE_NAME STATUS NUM_ROWS
------------------------------ -------- ----------
REGIONS VALID 4
LOCATIONS VALID 23
DEPARTMENTS VALID 27
JOBS VALID 19
EMPLOYEES VALID 107
JOB_HISTORY VALID 10
COUNTRIES VALID 25
7 rows selected.
Similar topics
» What Privilege Is Needed for a User to Query Tables in Another Schema?
» What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema?
» What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema?
» How To List All Indexes in Your Schema?
» How To Get a List of All Tables in the Database?
» What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema?
» What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema?
» How To List All Indexes in Your Schema?
» How To Get a List of All Tables in the Database?
SQL tutorial | Interview questions | Oracle :: Interview questions :: Oracle DBA Interview questions
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
Sun Jan 31, 2010 12:35 am by Micheal
» Accessing tables of other users in SQL
Sun Jan 31, 2010 12:34 am by Micheal
» Grouping commands in SQL
Sun Jan 31, 2010 12:32 am by Micheal
» Operations on Result Sets in SQL
Sun Jan 31, 2010 12:31 am by Micheal
» Subqueries in SQL
Sun Jan 31, 2010 12:30 am by Micheal
» Joining Relations in SQL
Sun Jan 31, 2010 12:28 am by Micheal
» Delete comand in SQL
Sun Jan 31, 2010 12:27 am by Micheal
» Update command in SQL
Sun Jan 31, 2010 12:26 am by Micheal
» Insert command in SQL
Sun Jan 31, 2010 12:23 am by Micheal