Creating a Default Sequence and Trigger

In the Edit Table dialog, selecting Populate Column from a Sequence on insert on a column creates a default sequence for that column, and an associated trigger.

In this example, PERSONS_SEQ is created. PERSONS_TRG is created to insert the next value of the sequence into the PERSON_ID column.

Copyright © 1997, 2009, Oracle. All rights reserved.