> For the complete documentation index, see [llms.txt](https://docs.tribalknowledge.tech/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tribalknowledge.tech/kulvert/ci-cd-pipeline/oracle-setup/create-sql-file-for-kulvert.md).

# Create SQL File for Kulvert

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

```plsql
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;
```