Re: Dynamic Generate sequences ~~

From: Chun-Yen <agi_at_haa.com.tw>
Date: Mon, 28 Aug 2000 07:24:40 GMT
Message-ID: <8od43e$dhj$1@nnrp1.deja.com>

In article <8od2jp$api$1_at_nnrp1.deja.com>,   handyn_at_my-deja.com wrote:
> Actually I'm not quite sure what you mean.
>
> by the way from beginning, you just create your sequence e.g : MySeq
> then create the trigger.
>
> Create or replace trigger TAB_Ins
> before insert on YOUR_TABLE for each row
> declare
> x number;
> Begin
> select MySeq.nextval
> into x
> from dual;
> :new.Field := x;
> end;
>
> I hope it could solve your problem
>
> Handy

Handy,
  Thanks for your reply~~
  My problem is that once the whenever a new record added,   a new sequence will be generated automatically.   For example, mytable( kind number(4), name varchar2(32))

  kind     name
  ----     --------
     1     IT
     2     HR
     3     MFG

  ......
  Of course, that kind is auto assigned by trigger and sequence.   my problem is that after inserting (1,IT), a "new" sequence   seq_kind_1 will be generated automatically for later usage.   ps: same as (2, HR) seq_kind_2 will be generated,too

Agi
>
> In article <8ocn5e$us6$1_at_nnrp1.deja.com>,
> Chun-Yen <agi_at_haa.com.tw> wrote:
> > Hello,theres
> >
> > Could I use trigger to dynamic generate sequences??
> > My goal is whenever a new record insert, a sequence generated.
> > for example, table test( c1 number, c2 varchar2(100)),
> > Now, c1 is automatic assigned by trigger and a sequence. 1 2 3...
> > How to generate seq_test1 for 1st record,seq_test2 for 2nd
 record...
> > once a new record insert a new sequence must generate.
> >
> > "It seems *impossible* since COMMIT is not allowed in trigger."
> > Any ideas ??
> >
> > Agi
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 28 2000 - 02:24:40 CDT