-
Find a table name
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
-
SELECT table_name FROM all_tab_columns WHERE column_name = 'string';???
-
no, since it's brute force you have to code one yourself!
-
I've got lets say 100 tables and 10 columns at each but only 5 rows per table so db is not big. But i want to find a string in such DB. Is there any tool for this or procedure?
-
No, there is no such tool.
-
search asktom for search_schema (he wrote one)
-
Originally Posted by alldaron@wp.pl
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
Please get rid of the application designer ASAP.
Tamil
-
Originally Posted by tamilselvan
Please get rid of the application designer ASAP.
Tamil
Why? why would the front end user need to know what tables are being used in the gui?
-
Originally Posted by davey23uk
Why? why would the front end user need to know what tables are being used in the gui?
Assume the following two tables exist in a schema.
CUSTOMER
CUSTOMER_ID NUMBER
LAST_NAME VARCHAR2(30)
FIRST_NAME VARCHAR2(30)
SUPPLIER
SUPPLIER_ID NUMBER
LAST_NAME VARCHAR2(30)
FIRST_NAME VARCHAR2(30)
SELECT table_name FROM all_tab_columns
WHERE column_name = 'LAST_NAME'
will return both CUSTOMER and SUPPLIER tables.
Now tell me which one do you want?
Tamil
www.beaconinfotechcorp.com
-
but thats nothing to do with the original quesrion
he had no idea what tables his app was using (and why should he)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|