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