How to list Oracle tables

How to list Oracle tables

Displaying the list of tables present in an Oracle database is quite easy to do.

To display the list of tables in an Oracle database:

  • To list all the tables related to the current user: SELECT table_name FROM user_tables.
  • To list the tables accessible by the user: SELECT table_name FROM all_tables.
  • To list all of the tables (ADMIN): SELECT table_name FROM dba_tables.
any more questions about databases? check out our forum!
Subject Replies
Laptop screen blank when switched on 391
After start up only wallpaper shows, no icons 258
Can't exit Power saving mode 38
Acer laptop wont start up ! 50
Laptop shut off, will not turn back on 251

Databases