Show All Tables in the Database in Oracle


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



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

2018-10-08, 704👍, 0💬