Show All Tables in the Database in Oracle

Q

How To Get a List of All Tables in the Database in Oracle?

✍: FYIcenter.com

A

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.

 

Introduction to Oracle SQL Developer

⇒⇒Oracle Database Tutorials

2016-10-17, 164👍, 0💬