Home » SQL & PL/SQL » SQL & PL/SQL » how to find out name of table if we dont know it
how to find out name of table if we dont know it [message #279987] Mon, 12 November 2007 04:08 Go to next message
mrkcse
Messages: 62
Registered: November 2007
Location: Mumbai,India
Member
Hi ,


How to find out a table name from 200 tables where field name of one table we know.If we dont know table names at all.




If anyone know this please reply.
Re: how to find out name of table if we dont know it [message #279989 is a reply to message #279987] Mon, 12 November 2007 04:16 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

just to answer your question.look in user_tab_columns.what if there are two tables having the same field name?


regards,
Re: how to find out name of table if we dont know it [message #279990 is a reply to message #279987] Mon, 12 November 2007 04:16 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SELECT * FROM USER_TAB_COLUMNS
WHERE COLUMN_NAME = 'COLUMN_NAME_YOU_KNOW';
Re: how to find out name of table if we dont know it [message #279991 is a reply to message #279987] Mon, 12 November 2007 04:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
user/all/dba_tab_columns

Regards
Michel
Re: how to find out name of table if we dont know it [message #279999 is a reply to message #279987] Mon, 12 November 2007 04:36 Go to previous messageGo to next message
mrkcse
Messages: 62
Registered: November 2007
Location: Mumbai,India
Member
thanks for your replies. I got the hint.
Re: how to find out name of table if we dont know it [message #280010 is a reply to message #279999] Mon, 12 November 2007 05:01 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Wow, 3 answers at the same time!!! Perhaps we should include seconds when displaying posting time?
Previous Topic: REPLACING only on specified locations
Next Topic: Help with Query
Goto Forum:
  


Current Time: Thu Dec 08 12:53:17 CST 2016

Total time taken to generate the page: 0.09602 seconds