manishayadav_1

 Profile Answers by manishayadav_1 Questions by manishayadav_1

• Apr 23rd, 2008

 

select * from tab;

Imran_Javed

 Profile Answers by Imran_Javed 

• May 8th, 2008

 

SELECT TABLE_NAME FROM All_TABLES
Order by TABLE_NAME;

The above query will display all the table names in the database.

SELECT TABLE_NAME FROM USER_TABLES
Order by TABLE_NAME;

The above query will display all the table names in a particular schema.

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 20th, 2008

 

To view tables in the current schema
SELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TABLE'

To view all the tables that you have access
SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'TABLE'

To view all the tables in the database
SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_TYPE = 'TABLE'


You may use user_tables instead of user_objects.