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
How To Get a List of All Tables in the Database?
If you don't like to use a SELECT statement to get a list of all tables in the current database, you can use the Reports view to do this as shown in the following tutorial example:
Click menu View.
Selects Reports from the menu.
Open Reports.
Open Data Dictionary Reports.
Open Table.
Double-click User Tables. You see the Enter Bind Values window.
Click Apply.
You should get a list all current tables in the database.
Click menu View.
Selects Reports from the menu.
Open Reports.
Open Data Dictionary Reports.
Open Table.
Double-click User Tables. You see the Enter Bind Values window.
Click Apply.
You should get a list all current tables in the database.
Similar topics
» How To List All Tables in Your Schema?
» How To Get a List of All User Accounts in the Database?
» What are the components of physical database structure of Oracle database?
» 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?
» How To Get a List of All User Accounts in the Database?
» What are the components of physical database structure of Oracle database?
» 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?
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