Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Find a table name
alldaron
post Apr 13 2006, 10:54 AM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 13-April 06
Member No.: 4,050



Hi,

Do anobody knows any procedure at PL/SQL which returns name of table and column which contain a desired value. I'm adding something to database threw GUI and I dont know in which table this value is added. Maybe there is some procedure which do somethong like this:

select * from * where exist ‘some string’
Go to the top of the page
 
+Quote Post
burleson
post Apr 15 2006, 09:39 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,309
Joined: 26-January 04
Member No.: 13



Hi,

try this:

select table_name from dba_tables where table_name like '%mystring%';

select column_name from dba_tab_columns where column_name like '%mystring%';


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd July 2014 - 10:25 AM