Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: SQL
Expertise: Beginner
Feb 20, 2017



Full Text Search: The Key to Better Natural Language Queries for NoSQL in Node.js

Get a List of all Tables In Oracle SQL

Sometimes, you need to see a list of all the tables in the database. In Oracle, you can query the data dictionary to see this.

There are several views in the data dictionary you can query, and which ones you can see will depend on your privileges. The easiest way to see all tables in the database is to query the all_tables view:

SELECT owner, table_name FROM all_tables;

This will show the owner (the user) and the name of the table. You don't need any special privileges to see this view, but it only shows tables that are accessible to you.

If you have administrator privileges, you can query the dba_tables view, which gives you a list of all tables in the database.

Ben Brumm
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date