query to get list of tables

[richardson]

How to list all the tables created in oracle.
how to create views on tables and wat r they for...im very new to oracle...pls help me..

[palani12kumar]

Try this to see all the tables created:

 
SQL>select * from tab;
 
 

[yadav]

Try this to see all the tables created:

SQL>select * from tab;

 
sql>>select tname from tab:
 
 

this will give u the list of tables
view:
views are used to combine 2 or more tables data into one table so as to avoid
joining conditions for the repeatedly used data.



cheers
yadav

[richardson]

sql>>select tname from tab:
this will give u the list of tables
view:
views are used to combine 2 or more tables data into one table so as to avoid
joining conditions for the repeatedly used data.



cheers
yadav

Thanks for ur reply yadav....

wat is the difference from using

 
select * from tab (select tname from tab)
 
--and
 
select * from user_tables
 

wen would their usage is appropriate...
wat is the previledges offered by a dba in such scenarios to a normal user.

[bhartiakhilesh]

How to list all the tables created in oracle.
how to create views on tables and wat r they for...im very new to oracle...pls help me..

simple way to find all tables created by user

SELECT*FROM TAB;
 

[sowmy]

How to list all the tables created in oracle.
how to create views on tables and wat r they for...im very new to oracle...pls help me..

 
SELECT * FROM user_tables;
 
--or
 
SELECT table_name FROM user_tables;
 
 

[amitpatel66]

Hi All,

Please make sure you make use of [code] tags when ever you post any source code in this forum.

MODERATOR