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.

 

Show All User Accounts in the Database in Oracle

Report View in SQL Developer in Oracle

Introduction to Oracle SQL Developer

⇑⇑ Oracle Database Tutorials

2018-10-08, 1340🔥, 0💬