Create SQL File for Sanity Check

Create a text file with the name payrollmods.plsql. Put the following text in the file:

insert into payroll (payroll_id, employee_id, paycheck_status, account_number) 
values (6, 1, 'V','00001234');
insert into payroll (payroll_id, employee_id, paycheck_status, account_number) 
values (7, 2, 'R','00001234');


update payroll
set paycheck_status = 'X'
where payroll_id = 8;