Re: triggers & sequences

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 27 Mar 2001 09:30:23 +0200
Message-ID: <99pfig$gd8$1@s1.read.news.oleane.net>

"almir" <a.kazazic_at_medienhaus.co.at> a écrit dans le message news: 985626549.956498_at_newsmaster-04.atnet.at...
> is there are a way to find out which sequence is used by which trigger or
> something like that
>
> thanks
> almir
>
>

select referenced_owner, referenced_name from dba_dependencies
where owner='<trigger owner>'
and name='<trigger name>'
and referenced_type='SEQUENCE';

--
Have a nice day
Michel

Received on Tue Mar 27 2001 - 01:30:23 CST