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!
Databases
- Oracle show tables
- Oracle list tables
- Show tables oracle
- How To List the Tables in an Oracle Database
- Partitioning a Hard Drive for Mac, Windows, and Linux
- Table fit to page html > Guide
- Datediff oracle > Guide
- Oracle forgot password > Guide
- How to avoid duplicate records in SQL: select query
- How to reset a sequence in Oracle?