Simple query hangs !! help

From: Raj Rangarjan <raj_at_cs.clemson.edu>
Date: 1996/03/28
Message-ID: <4jesls$mad_at_hubcap.clemson.edu>#1/1

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

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'  not in 
                           ^^^^^^^
    (select column_name from sys.all_tab_columns
     where table_name=a.table_name);

spool off

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'
--

---

-Rajasekaran Rangarajan
-Administrative Progamming Services
-Clemson University
-Ph:(864) 656 0731/ Fax:(864) 656-0122
Received on Thu Mar 28 1996 - 00:00:00 CET