Sequence and Trigger

From: Tal Golan <talgolan_at_optic-nerve.com>
Date: Fri, 30 Oct 1998 10:59:05 -0800
Message-ID: <363a0b75.0@newsread.exodus.net>

Greetings:

I am new to the world of Oracle. I am attempting to convert a project form MSSQL over to Oracle8. Most of my tables require an IDENTITY column as part of each record. I understand that in Oracle I will need to employ a SEQUENCE, but I cannot figure out how to write the appropriate TRIGGER that will AUTOMATICALLY insert the NEXTVAL from the sequence.

Any help would be greatly appreciated.

Thanks.

Tal Golan
talgolan_at_optic-nerve.com Received on Fri Oct 30 1998 - 12:59:05 CST