Re: List of Tables

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Sat, 14 Oct 2000 12:26:14 +0200
Message-ID: <39E834C6.5181D4F1@0800-einwahl.de>

select	--+ rule
	distinct
	t1.owner


	, t1.table_name

from
	all_tab_columns t1


	, all_tab_columns t2

where 1 = 1
and t1.owner = t2.owner
and t1.table_name = t2.table_name
and 'KCM_TRANS_NBR' = t1.column_name
and 'CUST_ID' = t2.column_name
order by 1, 2
/

Martin Received on Sat Oct 14 2000 - 05:26:14 CDT