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

After start up only wallpaper shows, no icons 261

Laptop shut off, will not turn back on 251

Laptop screen blank when switched on 391

Internet connected but webpages won't load 31

Acer laptop wont start up ! 50

Around the same subject

Databases