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

Why can't I bridge connect? 15

Laptop screen blank when switched on 391

Itunes wants to delete all my songs 94

PC wont turn on. Fans spin loud. 14

Around the same subject

Databases