4.4 Create Two Sequences

Create two sequence objects, which will be used in INSERT statements to generate unique primary key values in the PATRONS and TRANSACTIONS tables.

1. In the SQL Worksheet, enter the following statements:

   CREATE SEQUENCE patron_id_seq 
   START WITH 100
   INCREMENT BY 1;

   CREATE SEQUENCE transaction_id_seq
   START WITH 100
   INCREMENT BY 1;