sqloracle-databaseoracle10goracle11g

difference between "tab" table and all_tables in oracle


what tables are returned by using (in oracle)

select * from tab

and

select * from all_tables

I would like to know the difference between two.


Solution

  • tab is an ancient data dictionary table that should never be used. It exists solely to provide backwards compatibility for scripts that were written potentially decades ago. tab does not get updated as new object types and new features get added.