> 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/ratifier-tutorials/sql-sanity-check/oracle-setup/create-sql-file-for-sanity-check.md).

# Create SQL File for Sanity Check

Create a text file with the name payrollmods.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');


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