anu_dw

 Profile Answers by anu_dw Questions by anu_dw

• Sep 15th, 2006

 

You can also use

select * from cat;

dev

• Sep 18th, 2006

 

Thank U Anu

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

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;

bhargav

• Nov 26th, 2006

 

Select * from dba_tables;

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 22nd, 2008

 

Synonym name	Synonym for Table
CAT	USER_CATALOG
CLU	USER_CLUSTERS
DICT	DICTIONARY
IND	USER_INDEXES
OBJ	USER_OBJECTS
SEQ	USER_SEQUENCES
SYS	USER_SYNONYMS
TAB	USER_TABLES

srividhya_85

 Profile Answers by srividhya_85 Questions by srividhya_85

• Jun 24th, 2008

 

Select distinct TABLE_NAME
from user_tab_columns;

vignesh

• Mar 7th, 2016

 

It shows error like table or view doesnt exist

sumanamara2016

 Profile Answers by sumanamara2016 

• Mar 18th, 2016

 

SELECT * FROM TAB
TABTYPE
-------
TABLE
SYNONYM
VIEW
TAB is included for compatibility. Oracle recommends that you do not use this view.

Visal

• Aug 13th, 2016

 

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

Ranaj Kumar Parida

• Aug 1st, 2017

 

SELECT * FROM ALL_OBJECTS

K SANTHOSH

• Aug 14th, 2017

 

SELECT TABLE_NAME
FROM USER_TABLES;

SuryaRS

 Profile Answers by SuryaRS 

• Aug 29th, 2017

 

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

Code
SELECT * FROM TAB


SELECT * FROM CAT

VIJAI VEDHA

• Sep 28th, 2022

 

ITS syn NOT sys,