create table paydata1 (idno varchar2(4), name varchar2(25), jobcode varchar2(1), salary number(7,2), payhr number(5,2)); insert into paydata1 values (1111,'Ann French','S',75000.00,0); insert into paydata1 values (2222,'Robert Costa','H',0,45.00); insert into paydata1 values (3333,'Linda Ames','H',0,50.00); insert into paydata1 values (4444,'Scott Brooks','S',78000.00,0); insert into paydata1 values (5555,'Susan Ash','S',57000.00,0); insert into paydata1 values (6666,'James Smith','S',55000.00,0); insert into paydata1 values (7777,'Mary Jones','H',0,36.00); insert into paydata1 values (8888,'John Morse','H',0,39.00); select * from paydata1;