SPOOL ld_data.err

PROMPT Inserting Data into 'COUNTRIES'

insert into countries (id, country) values (1, 'United Kingdom');
insert into countries (id, country) values (2, 'USA');
insert into countries (id, country) values (3, 'Ireland');
insert into countries (id, country) values (4, 'Canada');
insert into countries (id, country) values (5, 'France');
insert into countries (id, country) values (6, 'Germany');

commit;

PROMPT Inserting Data Into 'ITEMS'

insert into items (id,text,cost) values (1,'Big Tub of Ice Cream',2.95);
insert into items (id,text,cost) values (2,'6 Pack of Beer',4.95);
insert into items (id,text,cost) values (3,'Deep Pan Cheese Feast Pizza',5.95);
insert into items (id,text,cost) values (4,'1 Dozen Roses',12);
insert into items (id,text,cost) values (5,'Weekend in Amsterdam',156.78);
insert into items (id,text,cost) values (6,'1 Dozen Asprin',1.89);

commit;

Spool Off

