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');