Tribal Knowledge
  • Welcome
  • Getting Started
    • Install Guide
    • Introduction to Tribal Knowledge
      • About Exemplar
      • About Ratifier
      • About Kulvert
      • About Redactor
    • Supported Languages
  • Exemplar Tutorials
    • Knowledge Sharing Code Review
      • Create a New Project
      • Create a CheckList
      • Add Files for Code Review
      • Start Automated Code Review
  • Ratifier Tutorials
    • SQL Sanity Check
      • Oracle Setup
        • Oracle Database Setup
        • Create SQL File for Sanity Check
      • SQL Server Setup
        • SQL Server Database Setup
        • Copy of Create SQL File for Sanity Check
      • Create a New Project
      • Add SQL File for Sanity Check
      • SQL Sanity Check - Datasource Config
      • SQL Sanity Check - Start
    • SQL Simulator
      • Technical Overview
        • Step 1
        • Step 2
        • Step 3
        • Step 4
        • Step 5
      • Oracle Setup
        • Oracle Database Setup
        • Create SQL File for SQL Simulator
        • Create a New Project
        • Add SQL File for SQL Simulator
        • Datasource Config
        • Start Simulation
      • SQL Server Setup
        • SQL Server Database Setup
        • Create SQL File for SQL Simulator
        • Create a New Project
        • Add SQL File for SQL Simulator
        • Datasource Config
        • Start Simulation
  • Kulvert
    • CI/CD Pipeline
      • Oracle Setup
        • Oracle Database Setup
        • Create SQL File for Kulvert
      • SQL Server Setup
        • SQL Server Database Setup
        • Create SQL File for SQL simulator
      • Create a New Project
      • Add SQL File for Kulvert
      • Kulvert - Datasource Config
      • Kulvert - PipeLine Start
  • Redactor
    • About Redactor
  • About
    • About Tribal Knowledge
Powered by GitBook
On this page
  1. Kulvert
  2. CI/CD Pipeline
  3. Oracle Setup

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;

PreviousOracle Database SetupNextSQL Server Setup

Last updated 2 years ago