Re: Simple query hangs !! help

From: Charles Dye <cdye_at_dnt.dialog.com>
Date: 1996/03/28
Message-ID: <4jf6kf$cu8_at_iserv.dnt.dialog.com>#1/1


Raj,

SELECT table_name
FROM	dba_tab_columns
WHERE	column_name = 'FLAG_SELF_SUPPORTING'
/

Let's keep it simple!

Regards,
Charles_Dye_at_corp.dialog.com

In article <4jesls$mad_at_hubcap.clemson.edu>, raj_at_cs.clemson.edu (Raj Rangarjan) writes:
> Hi,
> Anyone know of a reson why this query hangs
> spool flag.tmp
> set head off
> select distinct table_name from
> sys.all_tab_columns a
> where (owner='AIS' or owner='PDS')
> and 'FLAG_SELF_SUPPORTING' in
> (select column_name from sys.all_tab_columns
> where table_name=a.table_name);
> spool off
>
> whereas this one works fine
>
 <snip>
> All I am doing is selecting a list of tables which do have a particular
> field_name in the first query and choosing the list of tables that do
> have the field name. The field name in the above two queries are
> 'FLAG_SELF_SUPPORTING'
>
Received on Thu Mar 28 1996 - 00:00:00 CET

Original text of this message