Hi Markus!
Here's a recipe that might help you (assuming your table is called MYTABLE:
1. create a sequence:
CREATE SEQUENCE MYTABLE_Sequence start with 1 increment by 1 nocycle nocache;
2. create an insert trigger
CREATE OR REPLACE
TRIGGER MYTABLE_Insert_Trigger
BEFORE INSERT ON
Sorry I meant Hi Martin
-Original Message-
Sent: Tuesday, July 15, 2003 8:59 PM
To: Multiple recipients of list ORACLE-L
Hi Markus!
Here's a recipe that might help you (assuming your table is called MYTABLE:
1. create a sequence:
CREATE SEQUENCE MYTABLE_Sequence start with 1