OraFAQ Forum: SQL & PL/SQL » Identify table row

Home » SQL & PL/SQL » SQL & PL/SQL » Identify table row (Oracle 11.2.0.2.0,Linux 5.6)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Identify table row [message #570712]

Wed, 14 November 2012 15:55

Jack14
Messages: 333
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

Report message to a moderator

Re: Identify table row [message #570715 is a reply to message #570712]

Wed, 14 November 2012 17:02

BlackSwan
Messages: 20108
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.

Report message to a moderator

Re: Identify table row [message #570717 is a reply to message #570715]

Wed, 14 November 2012 17:11

Jack14
Messages: 333
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.

Report message to a moderator

Re: Identify table row [message #570719 is a reply to message #570717]

Wed, 14 November 2012 17:27

BlackSwan
Messages: 20108
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?

Report message to a moderator

Re: Identify table row [message #570720 is a reply to message #570719]

Wed, 14 November 2012 17:33

Jack14
Messages: 333
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

BlackSwan
Messages: 20108
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?

Report message to a moderator

Re: Identify table row [message #570733 is a reply to message #570712]

Thu, 15 November 2012 01:10

Michel Cadot
Messages: 54226
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Go to AskTom and search for find_string procedure.

Regards
Michel

Report message to a moderator

Previous Topic:	Check Constraint
Next Topic:	how we resolve INVALID object

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 01:33:11 CDT 2013

Total time taken to generate the page: 0.17062 seconds