Re: search fields

-----------------------------------------------
set linesize 75
col owner form a25
col table_name form a30
SELECT owner, table_name FROM dba_tab_columns
WHERE lower(column_name) = 'medicode'
ORDER BY owner, table_name;
clear col
--------------------------------------------
cut and paste above command at sqlplus
execute above command will give you list of table with medicode column


----- Original Message ----- 
From: "Kean Jacinta" <jacintakean@xxxxxxxxx>
To: <all_about_oracle@xxxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, May 27, 2005 3:52 PM
Subject: Re: search fields


> 
> What is this ('   .)?
> > where table_name in ('   .)
> 
> 
> --- Oracle <all_about_oracle@xxxxxxxxxx> wrote:
> > select table_name from dba_Tab_columns
> > where table_name in ('   .)
> > and column_name is .....
> > 
> > ----- Original Message ----- 
> > From: "Kean Jacinta" <jacintakean@xxxxxxxxx>
> > To: <oracle-l@xxxxxxxxxxxxx>
> > Sent: Friday, May 27, 2005 2:33 PM
> > Subject: search fields
> > 
> > 
> > > hi ,
> > > 
> > > Just want to know , would it be possible to search
> > all
> > > tables that contains medicode. 
> > > 
> > > Giving an example: i have 15 tables .And only 9
> > tables
> > > contains medicode. The field name medicode is d
> > same
> > > in all the 9 tables.
> > > 
> > > Is tat possible to query sql statement to show all
> > > tables that contains medicode fields ?
> > > 
> > > If there are none , can you please suggest other
> > ways
> > > to obtain it ? 
> > > 
> > > Thank You
> > > 
> > > JK 
> > > 
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam?  Yahoo! Mail has the best spam
> > protection around 
> > > http://mail.yahoo.com 
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > > 
> > 
> > 
> > --
> > http://www.freelists.org/webpage/oracle-l
> > 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com


--
http://www.freelists.org/webpage/oracle-l

Other related posts: