Hello, I m creating Trigger in H2 database, But I don't H2 database, Please help to convert below oracle query into H2 database
CREATE TRIGGER IDN_CERTIFICATE_TRIGGER BEFORE INSERT ON IDN_CERTIFICATE REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT IDN_CERTIFICATE_SEQUENCE.nextval INTO :NEW.ID FROM dual; END; On Saturday, February 2, 2008 at 12:31:39 PM UTC-5, Szaijan wrote: > > Thank you Thomas, that's a big help. I missed the AUTO_INCREMENT > option in the CREATE_TABLE syntax. Thinking about the problem > further, I can actually just use UUID for the field with a random UUID > default value and let the PRIMARY KEY constraint prevent users from > shoving in their own non-unique values. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/e2439dbb-6b1c-4c2d-94fc-79293b11e9b5o%40googlegroups.com.
