Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: triggers & sequences

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US