SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between all_tab, all_all_tab, tab from data dictionary

venkatOct 15 2008 — edited Oct 15 2008

Hi,
I used following three table names to get all tables from current schema.
But I got diffrent outputs from TAB and ALL_ALL_TABLES.

please guide me what is the diffrence between tab, all_all_tables and all_tables.
and what is the right query to get all_table information from the logged on schema/user.

SQL>SELECT COUNT(*) FROM tab
218
SQL>SELECT COUNT(*) FROM all_all_tables
367

SQL>SELECT COUNT(*) FROM all_tables
367

Thanks and regards,
Venkat.

This post has been answered by Karthick2003 on Oct 15 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2008

Added on Oct 15 2008

5 comments

1,136 views