Create SQL File for Kulvert
Create a text file with the name payrollinserts.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');
udpate payroll
set paycheck_status = 'X'
where payroll_id = 8;
Last updated