Answers

Question and Answer:

  Home  Oracle Database

⟩ 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.

 206 views

More Questions for you: