Employee Table Insert Statement

This section provides a sample employee table insert statement.

Generic Sample
INSERT INTO EMP
(
EMPLOYEE_ID
, FIRST_NAME
, LAST_NAME
, EMAIL
, PHONE_NUMBER
, HIRE_DATE
, JOB_ID
, SALARY
, COMMISSION_PCT
, MANAGER_ID
, DEPARTMENT_ID
)
VALUES
(
  ?xEmpID
,'?xFirstName'
,'?xLastName'
,'?xEmail'
,'?xPhone'
,'?xHireDate'
,'?xJobID'
,?xSalary
,?xCommPCT
,?xMgrID
,?xDeptID
)

iWay Software