dba_views

How Can I See All Tables In Oracle SQL? 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