Oracle Sequence Triggers
The RazorSQL alter table tool includes an Add Sequence Trigger option for adding a sequence trigger to an Oracle database table. The add sequence trigger option has a dropdown with the sequences defined in the database. After the user selects a sequence, the user can enter a trigger name and a sequence column, and RazorSQL will generate the SQL to create the sequence trigger on the table.
Listed below is an example of the SQL generated by the Oracle Add Sequence Trigger function:
CREATE OR REPLACE TRIGGER TEST_SEQ_TRIGGER
BEFORE INSERT ON TESTUSER.EMPLOYEE
FOR EACH ROW
BEGIN
IF :new.SSN IS NULL THEN
SELECT TEST_SEQUENCE.nextval INTO :new.SSN FROM DUAL;
END IF;
END;
Below is a screen shot of the add sequence trigger function of the Oracle alter table tool.
