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.