Home » SQL & PL/SQL » SQL & PL/SQL » Cant see the Table Name..
Cant see the Table Name.. [message #202925] Mon, 13 November 2006 05:45 Go to next message
monuprasad
Messages: 1
Registered: November 2006
Junior Member
Hi All,

Can anyone please tell me, How do i see a particualr table in the Database?

Actually i know the name of the table, but when i am using these queries:

SQL> select * from tab;
SQL> select * from cat;
SQL> select * from user_tab_columns;

I am not able to see the Table I am looking for..

Please help me out..

Regards.
Monu
Re: Cant see the Table Name.. [message #202926 is a reply to message #202925] Mon, 13 November 2006 05:49 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
First confirm whether it is a table or not....

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME = '<table_name>';

depending on the object_type...
check all_tables, all_views or all_synonyms

By
Vamsi.
Re: Cant see the Table Name.. [message #202927 is a reply to message #202925] Mon, 13 November 2006 05:49 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

if you are the owner of the table then use the below query.else check in ALL_TABLES .
 select * from user_tables where table_name='YOUR_TABLE_NAME'



regards,

[Updated on: Mon, 13 November 2006 05:50]

Report message to a moderator

Re: Cant see the Table Name.. [message #203019 is a reply to message #202925] Mon, 13 November 2006 10:08 Go to previous message
Bill B
Messages: 1482
Registered: December 2004
Senior Member
user_tables - The tables in the connected user's schema ONLY.
all_tables - All tables that the connected user has the select privilege on.
dba_tables - ALL tables in the database, this view is only available to users with the DBA privilege.
Previous Topic: how to split a full name seperate names
Next Topic: XML file Synchronization
Goto Forum:
  


Current Time: Fri Dec 02 16:18:59 CST 2016

Total time taken to generate the page: 0.21837 seconds