Hi,Select * from tab; - means we can see all the tables,right!is there any option similar to this..?

Showing Answers 1 - 10 of 10 Answers

dev

  • Sep 18th, 2006
 

Thank U Anu

Actually i used this 3 years back but i forgot it.

  Was this answer useful?  Yes

Ashish Seth

  • Sep 21st, 2006
 

The Main difference in "Select * from cat" & "Select * from tab" is that later doesn't include SEQUENCES in fetched records while former includes.

Sachin Bhatia

  • Oct 9th, 2006
 

Select * user_tables;

  Was this answer useful?  Yes

bhargav

  • Nov 26th, 2006
 

Select * from dba_tables;

  Was this answer useful?  Yes

vignesh

  • Mar 7th, 2016
 

It shows error like table or view doesnt exist

  Was this answer useful?  Yes

Visal

  • Aug 13th, 2016
 

You will have to query system database tables to see these details like dbc.tables

  Was this answer useful?  Yes

Ranaj Kumar Parida

  • Aug 1st, 2017
 

SELECT * FROM ALL_OBJECTS

  Was this answer useful?  Yes

K SANTHOSH

  • Aug 14th, 2017
 

SELECT TABLE_NAME
FROM USER_TABLES;

  Was this answer useful?  Yes

SuryaRS

  • Aug 29th, 2017
 

TAB will give tables, views whereas CAT will give tables, views, sequences. TAB is having clustered column.

Code
  1. SELECT * FROM TAB

  2. SELECT * FROM CAT

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions