Home » SQL & PL/SQL » SQL & PL/SQL » How to find table name and column name (Oracle 11.2.0.3.0 , Linux)
How to find table name and column name [message #584461] Tue, 14 May 2013 09:07 Go to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Hi,

With the help of data in a table, is it possible to find out the table name and column name ?
Means i know the account number (data) of the table and with the help of this data i want to
find out column name and table name.

Regards,

[Updated on: Tue, 14 May 2013 09:08]

Report message to a moderator

Re: How to find table name and column name [message #584462 is a reply to message #584461] Tue, 14 May 2013 09:15 Go to previous messageGo to next message
BlackSwan
Messages: 22802
Registered: January 2009
Senior Member
>With the help of data in a table, is it possible to find out the table name and column name ?
Why don't you know in which table & column the account number resides?
Ask the application architect where account number resides in the DB.


Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Re: How to find table name and column name [message #584464 is a reply to message #584461] Tue, 14 May 2013 09:22 Go to previous messageGo to next message
Michel Cadot
Messages: 59179
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
With the color of the eyes of someone can you know his/her name?

Regards
Michel
Re: How to find table name and column name [message #584479 is a reply to message #584464] Tue, 14 May 2013 11:14 Go to previous message
andrew again
Messages: 2574
Registered: March 2000
Senior Member
-- how to search tables & columns for specific value
http://www.orafaq.com/forum/t/47926/0/
Previous Topic: SQL Update statement for OLTP table
Next Topic: Query for below scenario using analytical functions
Goto Forum:
  


Current Time: Tue Sep 23 04:16:48 CDT 2014

Total time taken to generate the page: 0.13653 seconds