Dynamic Generate sequences ~~

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. Received on Sun Aug 27 2000 - 22:43:46 CDT