Home » RDBMS Server » Server Administration » Re: Database sweep
Re: Database sweep [message #374828] Thu, 05 July 2001 06:25
kavithask
Messages: 34
Registered: March 2001
Location: London
Member
Hi,

Execute the following select:
SELECT owner, table_name, column_name
FROM all_tab_columns
WHERE column_name = '&data_value'
/

The above select looks for all tables of all users to find for the columns which match the value specified.

HTH
Kavitha
Previous Topic: Altering Next clause in oracle database objects
Next Topic: Re: Ordered View
Goto Forum:
  


Current Time: Mon Dec 23 20:21:59 CST 2024