Trigger is your only option in Oracle.
Jurij Modic ASCII a stupid question, get a stupid ANSI 24 hours in a day .... 24 beer in a case .... coincidence?
You'd use a sequence, rather than a "counter table" ... something like ... Code: create sequence my_seq; Create or Replace Trigger BIR_MY_TABLE Before Insert On MY_TABLE For Each Row Begin Select my_seq.nextval Into :new.MY_TABLE# From Dual; End; /
create sequence my_seq; Create or Replace Trigger BIR_MY_TABLE Before Insert On MY_TABLE For Each Row Begin Select my_seq.nextval Into :new.MY_TABLE# From Dual; End; /
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Forum Rules