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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 03:58:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.