there is no such "tie in" between the two.


A sequence is entirely separate and distinct from the table - the sequence is a standalong object.


Now, that said, you can:

ops$tkyte%ORA10GR2> create table t ( x int primary key, y int );

Table created.

ops$tkyte%ORA10GR2> create sequence s;

Sequence created.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> create trigger t_trigger
2 before insert on t for each row
3 begin
4 if (:new.x is null )
5 then
6 select s.nextval into :new.x from dual;
7 end if;
8 end;
9 /

Trigger created.

ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> select referenced_name
2 from user_dependencies
3 where referenced_type = 'SEQUENCE'
4 and type = 'TRIGGER'
5 and name in (select trigger_name
6 from user_triggers
7 where table_name = 'T'
8 and table_owner = user)
9 /

REFERENCED_NAME
----------------------------------------------------------------
S


use the dependencies tables to find all of the sequences statically referenced by any of the triggers on a given table.