Home » SQL & PL/SQL » SQL & PL/SQL » Identify table row (Oracle 11.2.0.2.0,Linux 5.6)
Identify table row [message #570712] Wed, 14 November 2012 15:55 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

Is it possible to find the schema name,table name and DB name if we know a value in table ?

Thanks
Re: Identify table row [message #570715 is a reply to message #570712] Wed, 14 November 2012 17:02 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

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

>Is it possible to find the schema name,table name and DB name if we know a value in table ?

Yes, it is possible to do as above.
It is also possible to poke yourself in the eye with a sharp pencil;
but you'd be wise to avoid doing either action.


Re: Identify table row [message #570717 is a reply to message #570715] Wed, 14 November 2012 17:11 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Quote:
It is also possible to poke yourself in the eye with a sharp pencil;

Why should i poke myself in my eye with a sharp pencil .Am i mad like you to do so.
Re: Identify table row [message #570719 is a reply to message #570717] Wed, 14 November 2012 17:27 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
Why should you not know where data is stored in the DB?

What do you do if/when the value exists in multiple columns, rows, tables & databases?
Re: Identify table row [message #570720 is a reply to message #570719] Wed, 14 November 2012 17:33 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Quote:
What do you do if/when the value exists in multiple columns, rows, tables & databases?

This is what is my question is. If you know tell me the answer.

" BTW, why are you asking the same question to me in different ways." Razz

[Updated on: Wed, 14 November 2012 17:35]

Report message to a moderator

Re: Identify table row [message #570721 is a reply to message #570720] Wed, 14 November 2012 17:40 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
I don't understand what problem needs to be solved.
Why do you believe the data now resides in the DB?

> If you know tell me the answer.

The answer depends upon why this scavenger hunt is being done in the first place.
What needs to be done after you locate this "missing data"?
What if the value does not now reside in the DB?
Re: Identify table row [message #570733 is a reply to message #570712] Thu, 15 November 2012 01:10 Go to previous message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Go to AskTom and search for find_string procedure.

Regards
Michel
Previous Topic: Check Constraint
Next Topic: how we resolve INVALID object
Goto Forum:
  


Current Time: Sat Aug 30 21:17:35 CDT 2014

Total time taken to generate the page: 0.10825 seconds