DB Wiki

-- Lists the entrants in the sweepstake
DROP TABLE participants;
CREATE TABLE participants (ID NUMBER(2) generated BY DEFAULT ON NULL AS IDENTITY, 
                           Name varchar2(20), PRIMARY KEY(ID), 
						   CONSTRAINT unique_name UNIQUE (name));
INSERT INTO participants (name) VALUES ('Ian');
INSERT INTO participants (name) VALUES ('Pat');
INSERT INTO participants (name) VALUES ('Graham');
INSERT INTO participants (name) VALUES ('Tracy');
INSERT INTO participants (name) VALUES ('Michaela');
INSERT INTO participants (name) VALUES ('Glenn');