Re: Metadata/system catalog queries...
>> I took a stab at a simpler query (for only one table in MySql like)
>> select * from (show columns from t_sometable) where field like "%blah%'
SHOW COLUMNS FROM tbl_name LIKE "X%“
It will work for single table. I do not know how to query across tables.
You can export the create table statements of all tables to a single file and search within that file.
Subject
Written By
Posted
Re: Metadata/system catalog queries...
March 31, 2005 11:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.