Skip to content

Using a trigger

The same method can be used to create a DML script for the species table using another copy of the original spreadsheet. The difference this time is that the primary key is populated from a sequence by a trigger. You therefore only need to reference the other columns in your insert statements as shown below. Otherwise the series of steps is exactly the same as for the genus table.

Preparing data for the SPECIES table