Home » SQL & PL/SQL » SQL & PL/SQL » trying to find out table name based on a value
trying to find out table name based on a value [message #353717] Tue, 14 October 2008 17:22 Go to next message
ora1980
Messages: 251
Registered: May 2008
Senior Member
I was wondering whether there is a way to find out the table
name...given

1) just the value of a column

2) sometimes the value as well as column name
(DBA_TAB_COLUMNS)


Re: trying to find out table name based on a value [message #353720 is a reply to message #353717] Tue, 14 October 2008 19:00 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
you mean you want to search all tables and columns for a specified value?

If so, try to understand the general principle here and then modify to your need.
http://www.orafaq.com/forum/t/47926/0/
Re: trying to find out table name based on a value [message #353744 is a reply to message #353717] Tue, 14 October 2008 23:40 Go to previous message
Michel Cadot
Messages: 64136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search on AskTom for "find_string" function.

Regards
Michel
Previous Topic: extracting strings
Next Topic: Suggestion on Connect By query
Goto Forum:
  


Current Time: Thu Dec 08 06:13:34 CST 2016

Total time taken to generate the page: 0.11262 seconds