Subscribe Free | Archives | Custom Software Development | SEO | Free eBooks | Free Downloads | Submit Your Website | Website Dir

Get Latest Posts and eBooks Direct To Your Inbox

Wednesday, March 19, 2014

Posted by V. Kapoor
No comments | 5:21 AM
This is one of my most needed tool to create Insert and Update statements using select or alias from different tables where column mapping is difficult.

What this utility actually does is, suppose you have two table with too many columns and you want to update or insert in one table from another, you know column names but you want some visual interface so that your task can be easier. This tool provide the same facility to create insert or update statement by visually mapping fields from two tables.

The utility is created using Oracle Forms and can be used easily. Free download it from Tablemap.fmx

Below is the screen shots of this tool:








Continue Reading

Friday, March 7, 2014

Posted by V. Kapoor
No comments | 12:54 AM
A very informative video from +Matt Cutts of Google, explained very well on how Google search works when we type our query in Google search. 

This video is very helpful for SEO and Webmasters, after viewing this video they can have good idea on search result optimization.
Continue Reading

Wednesday, March 5, 2014

Posted by V. Kapoor
No comments | 11:28 PM

Search for jobs in multiple job portals at once:

Search Local Business Search FoxInfotech.in



Continue Reading
Posted by V. Kapoor
No comments | 3:55 AM

Type the local business name you are looking for...

Search in FoxInfotech.in Search For Jobs



Continue Reading

Tuesday, March 4, 2014

Posted by V. Kapoor
No comments | 11:29 PM
You can reverse a string in SQL by using Reverse function of SQL. It is very simple to use, following is the command to reverse a string:

SELECT reverse ('fox infotech') FROM DUAL;

And if you want to reverse a string manually using PL/SQL block, here is the example:

set serveroutput on;
DECLARE
   v_string    VARCHAR2 (1000);
   v_reverse   VARCHAR2 (1000);
BEGIN
   v_string := 'fox infotech';

   FOR n IN REVERSE 1 .. LENGTH (v_string)
   LOOP
      v_reverse := v_reverse || SUBSTR (v_string, n, 1);
   END LOOP;

   DBMS_OUTPUT.put_line (v_reverse);
END;
/

You can create your own function of above PLSQL block, as follows:

CREATE OR REPLACE FUNCTION my_reverse (v_string IN VARCHAR2)
   RETURN VARCHAR2
IS
   v_reverse   VARCHAR2 (4000);
BEGIN
   FOR n IN REVERSE 1 .. LENGTH (v_string)
   LOOP
      v_reverse := v_reverse || SUBSTR (v_string, n, 1);
   END LOOP;

   RETURN (v_reverse);
EXCEPTION
   WHEN OTHERS
   THEN
      RETURN ('');
END;
/

Use this function in your query:

SELECT my_reverse ('fox infotech') FROM DUAL;
Continue Reading
Posted by V. Kapoor
No comments | 12:55 AM
I have given many examples based on HR schema, hence I am providing here the HR schema script. Copy it from below:

CREATE TABLE HR.COUNTRIES
(
  COUNTRY_ID    CHAR(2 BYTE) CONSTRAINT COUNTRY_ID_NN NOT NULL,
  COUNTRY_NAME  VARCHAR2(40 BYTE),
  REGION_ID     NUMBER,
  CONSTRAINT COUNTRY_C_ID_PK
 PRIMARY KEY
 (COUNTRY_ID)
)
ORGANIZATION INDEX;

CREATE TABLE HR.DEPARTMENTS
(
  DEPARTMENT_ID    NUMBER(4),
  DEPARTMENT_NAME  VARCHAR2(30 BYTE) CONSTRAINT DEPT_NAME_NN NOT NULL,
  MANAGER_ID       NUMBER(6),
  LOCATION_ID      NUMBER(4)
);

CREATE TABLE HR.EMPLOYEES
(
  EMPLOYEE_ID     NUMBER(6),
  FIRST_NAME      VARCHAR2(20 BYTE),
  LAST_NAME       VARCHAR2(25 BYTE) CONSTRAINT EMP_LAST_NAME_NN NOT NULL,
  EMAIL           VARCHAR2(25 BYTE) CONSTRAINT EMP_EMAIL_NN NOT NULL,
  PHONE_NUMBER    VARCHAR2(20 BYTE),
  HIRE_DATE       DATE CONSTRAINT EMP_HIRE_DATE_NN NOT NULL,
  JOB_ID          VARCHAR2(10 BYTE) CONSTRAINT EMP_JOB_NN NOT NULL,
  SALARY          NUMBER(8,2),
  COMMISSION_PCT  NUMBER(2,2),
  MANAGER_ID      NUMBER(6),
  DEPARTMENT_ID   NUMBER(4)
);

CREATE TABLE HR.JOBS
(
  JOB_ID      VARCHAR2(10 BYTE),
  JOB_TITLE   VARCHAR2(35 BYTE) CONSTRAINT JOB_TITLE_NN NOT NULL,
  MIN_SALARY  NUMBER(6),
  MAX_SALARY  NUMBER(6)
);

CREATE TABLE HR.JOB_HISTORY
(
  EMPLOYEE_ID    NUMBER(6) CONSTRAINT JHIST_EMPLOYEE_NN NOT NULL,
  START_DATE     DATE CONSTRAINT JHIST_START_DATE_NN NOT NULL,
  END_DATE       DATE CONSTRAINT JHIST_END_DATE_NN NOT NULL,
  JOB_ID         VARCHAR2(10 BYTE) CONSTRAINT JHIST_JOB_NN NOT NULL,
  DEPARTMENT_ID  NUMBER(4)
);

CREATE TABLE HR.LOCATIONS
(
  LOCATION_ID     NUMBER(4),
  STREET_ADDRESS  VARCHAR2(40 BYTE),
  POSTAL_CODE     VARCHAR2(12 BYTE),
  CITY            VARCHAR2(30 BYTE) CONSTRAINT LOC_CITY_NN NOT NULL,
  STATE_PROVINCE  VARCHAR2(25 BYTE),
  COUNTRY_ID      CHAR(2 BYTE)
);

CREATE TABLE HR.REGIONS
(
  REGION_ID    NUMBER CONSTRAINT REGION_ID_NN   NOT NULL,
  REGION_NAME  VARCHAR2(25 BYTE)
);

CREATE UNIQUE INDEX HR.DEPT_ID_PK ON HR.DEPARTMENTS
(DEPARTMENT_ID);

CREATE INDEX HR.DEPT_LOCATION_IX ON HR.DEPARTMENTS
(LOCATION_ID);

CREATE INDEX HR.EMP_DEPARTMENT_IX ON HR.EMPLOYEES
(DEPARTMENT_ID);

CREATE UNIQUE INDEX HR.EMP_EMAIL_UK ON HR.EMPLOYEES
(EMAIL);

CREATE UNIQUE INDEX HR.EMP_EMP_ID_PK ON HR.EMPLOYEES
(EMPLOYEE_ID);

CREATE INDEX HR.EMP_JOB_IX ON HR.EMPLOYEES
(JOB_ID);

CREATE INDEX HR.EMP_MANAGER_IX ON HR.EMPLOYEES
(MANAGER_ID);

CREATE INDEX HR.EMP_NAME_IX ON HR.EMPLOYEES
(LAST_NAME, FIRST_NAME);

CREATE INDEX HR.JHIST_DEPARTMENT_IX ON HR.JOB_HISTORY
(DEPARTMENT_ID);

CREATE INDEX HR.JHIST_EMPLOYEE_IX ON HR.JOB_HISTORY
(EMPLOYEE_ID);

CREATE UNIQUE INDEX HR.JHIST_EMP_ID_ST_DATE_PK ON HR.JOB_HISTORY
(EMPLOYEE_ID, START_DATE);

CREATE INDEX HR.JHIST_JOB_IX ON HR.JOB_HISTORY
(JOB_ID);

CREATE UNIQUE INDEX HR.JOB_ID_PK ON HR.JOBS
(JOB_ID);

CREATE INDEX HR.LOC_CITY_IX ON HR.LOCATIONS
(CITY);

CREATE INDEX HR.LOC_COUNTRY_IX ON HR.LOCATIONS
(COUNTRY_ID);

CREATE UNIQUE INDEX HR.LOC_ID_PK ON HR.LOCATIONS
(LOCATION_ID);

CREATE INDEX HR.LOC_STATE_PROVINCE_IX ON HR.LOCATIONS
(STATE_PROVINCE);

CREATE UNIQUE INDEX HR.REG_ID_PK ON HR.REGIONS
(REGION_ID);

CREATE OR REPLACE TRIGGER HR.secure_employees
  BEFORE INSERT OR UPDATE OR DELETE ON employees
DISABLE
BEGIN
  secure_dml;
END secure_employees;
/


CREATE OR REPLACE TRIGGER HR.update_job_history
  AFTER UPDATE OF job_id, department_id ON employees
  FOR EACH ROW
BEGIN
  add_job_history(:old.employee_id, :old.hire_date, sysdate,
                  :old.job_id, :old.department_id);
END;
/


ALTER TABLE HR.DEPARTMENTS ADD (
  CONSTRAINT DEPT_ID_PK
 PRIMARY KEY
 (DEPARTMENT_ID));

ALTER TABLE HR.EMPLOYEES ADD (
  CONSTRAINT EMP_SALARY_MIN
 CHECK (salary > 0),
  CONSTRAINT EMP_EMP_ID_PK
 PRIMARY KEY
 (EMPLOYEE_ID),
  CONSTRAINT EMP_EMAIL_UK
 UNIQUE (EMAIL));

ALTER TABLE HR.JOBS ADD (
  CONSTRAINT JOB_ID_PK
 PRIMARY KEY
 (JOB_ID));

ALTER TABLE HR.JOB_HISTORY ADD (
  CONSTRAINT JHIST_DATE_INTERVAL
 CHECK (end_date > start_date),
  CONSTRAINT JHIST_EMP_ID_ST_DATE_PK
 PRIMARY KEY
 (EMPLOYEE_ID, START_DATE));

ALTER TABLE HR.LOCATIONS ADD (
  CONSTRAINT LOC_ID_PK
 PRIMARY KEY
 (LOCATION_ID));

ALTER TABLE HR.REGIONS ADD (
  CONSTRAINT REG_ID_PK
 PRIMARY KEY
 (REGION_ID));
SET DEFINE OFF;
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('AR', 'Argentina', 2);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('AU', 'Australia', 3);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('BE', 'Belgium', 1);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('BR', 'Brazil', 2);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('CA', 'Canada', 2);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('CH', 'Switzerland', 1);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('CN', 'China', 3);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('DE', 'Germany', 1);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('DK', 'Denmark', 1);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('EG', 'Egypt', 4);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('FR', 'France', 1);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('HK', 'HongKong', 3);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('IL', 'Israel', 4);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('IN', 'India', 3);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('IT', 'Italy', 1);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('JP', 'Japan', 3);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('KW', 'Kuwait', 4);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('MX', 'Mexico', 2);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('NG', 'Nigeria', 4);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('NL', 'Netherlands', 1);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('SG', 'Singapore', 3);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('UK', 'United Kingdom', 1);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('US', 'United States of America', 2);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('ZM', 'Zambia', 4);
Insert into HR.COUNTRIES
   (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
 Values
   ('ZW', 'Zimbabwe', 4);
COMMIT;

SET DEFINE OFF;
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (10, 'Administration', 200, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (20, 'Marketing', 201, 1800);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (30, 'Purchasing', 114, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (40, 'Human Resources', 203, 2400);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (50, 'Shipping', 121, 1500);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (60, 'IT', 103, 1400);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (70, 'Public Relations', 204, 2700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (80, 'Sales', 145, 2500);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (90, 'Executive', 100, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (100, 'Finance', 108, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (110, 'Accounting', 205, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (120, 'Treasury', NULL, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (130, 'Corporate Tax', NULL, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (140, 'Control And Credit', NULL, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (150, 'Shareholder Services', NULL, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (160, 'Benefits', NULL, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (170, 'Manufacturing', NULL, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (180, 'Construction', NULL, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (190, 'Contracting', NULL, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (200, 'Operations', NULL, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (210, 'IT Support', NULL, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (220, 'NOC', NULL, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (230, 'IT Helpdesk', NULL, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (240, 'Government Sales', NULL, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (250, 'Retail Sales', NULL, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (260, 'Recruiting', NULL, 1700);
Insert into HR.DEPARTMENTS
   (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
 Values
   (270, 'Payroll', NULL, 1700);
COMMIT;

SET DEFINE OFF;
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (100, 'Steven', 'King', 'SKING', '515.123.4567',
    TO_DATE('06/17/1987 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AD_PRES', 24000, NULL, NULL,
    90);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (101, 'Neena', 'Kochhar', 'NKOCHHAR', '515.123.4568',
    TO_DATE('09/21/1989 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AD_VP', 17000, NULL, 100,
    90);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (102, 'Lex', 'De Haan', 'LDEHAAN', '515.123.4569',
    TO_DATE('01/13/1993 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AD_VP', 17000, NULL, 100,
    90);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (103, 'Alexander', 'Hunold', 'AHUNOLD', '590.423.4567',
    TO_DATE('01/03/1990 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'IT_PROG', 9000, NULL, 102,
    60);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (104, 'Bruce', 'Ernst', 'BERNST', '590.423.4568',
    TO_DATE('05/21/1991 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'IT_PROG', 6000, NULL, 103,
    60);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (105, 'David', 'Austin', 'DAUSTIN', '590.423.4569',
    TO_DATE('06/25/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'IT_PROG', 4800, NULL, 103,
    60);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (106, 'Valli', 'Pataballa', 'VPATABAL', '590.423.4560',
    TO_DATE('02/05/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'IT_PROG', 4800, NULL, 103,
    60);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (107, 'Diana', 'Lorentz', 'DLORENTZ', '590.423.5567',
    TO_DATE('02/07/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'IT_PROG', 4200, NULL, 103,
    60);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (108, 'Nancy', 'Greenberg', 'NGREENBE', '515.124.4569',
    TO_DATE('08/17/1994 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'FI_MGR', 12000, NULL, 101,
    100);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (109, 'Daniel', 'Faviet', 'DFAVIET', '515.124.4169',
    TO_DATE('08/16/1994 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'FI_ACCOUNT', 9000, NULL, 108,
    100);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (110, 'John', 'Chen', 'JCHEN', '515.124.4269',
    TO_DATE('09/28/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'FI_ACCOUNT', 8200, NULL, 108,
    100);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (111, 'Ismael', 'Sciarra', 'ISCIARRA', '515.124.4369',
    TO_DATE('09/30/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'FI_ACCOUNT', 7700, NULL, 108,
    100);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (112, 'Jose Manuel', 'Urman', 'JMURMAN', '515.124.4469',
    TO_DATE('03/07/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'FI_ACCOUNT', 7800, NULL, 108,
    100);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (113, 'Luis', 'Popp', 'LPOPP', '515.124.4567',
    TO_DATE('12/07/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'FI_ACCOUNT', 6900, NULL, 108,
    100);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (114, 'Den', 'Raphaely', 'DRAPHEAL', '515.127.4561',
    TO_DATE('12/07/1994 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PU_MAN', 11000, NULL, 100,
    30);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (115, 'Alexander', 'Khoo', 'AKHOO', '515.127.4562',
    TO_DATE('05/18/1995 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PU_CLERK', 3100, NULL, 114,
    30);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (116, 'Shelli', 'Baida', 'SBAIDA', '515.127.4563',
    TO_DATE('12/24/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PU_CLERK', 2900, NULL, 114,
    30);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (117, 'Sigal', 'Tobias', 'STOBIAS', '515.127.4564',
    TO_DATE('07/24/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PU_CLERK', 2800, NULL, 114,
    30);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (118, 'Guy', 'Himuro', 'GHIMURO', '515.127.4565',
    TO_DATE('11/15/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PU_CLERK', 2600, NULL, 114,
    30);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (119, 'Karen', 'Colmenares', 'KCOLMENA', '515.127.4566',
    TO_DATE('08/10/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PU_CLERK', 2500, NULL, 114,
    30);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (120, 'Matthew', 'Weiss', 'MWEISS', '650.123.1234',
    TO_DATE('07/18/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_MAN', 8000, NULL, 100,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (121, 'Adam', 'Fripp', 'AFRIPP', '650.123.2234',
    TO_DATE('04/10/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_MAN', 8200, NULL, 100,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (122, 'Payam', 'Kaufling', 'PKAUFLIN', '650.123.3234',
    TO_DATE('05/01/1995 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_MAN', 7900, NULL, 100,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (123, 'Shanta', 'Vollman', 'SVOLLMAN', '650.123.4234',
    TO_DATE('10/10/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_MAN', 6500, NULL, 100,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (124, 'Kevin', 'Mourgos', 'KMOURGOS', '650.123.5234',
    TO_DATE('11/16/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_MAN', 5800, NULL, 100,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (125, 'Julia', 'Nayer', 'JNAYER', '650.124.1214',
    TO_DATE('07/16/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 3200, NULL, 120,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (126, 'Irene', 'Mikkilineni', 'IMIKKILI', '650.124.1224',
    TO_DATE('09/28/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2700, NULL, 120,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (127, 'James', 'Landry', 'JLANDRY', '650.124.1334',
    TO_DATE('01/14/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2400, NULL, 120,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (128, 'Steven', 'Markle', 'SMARKLE', '650.124.1434',
    TO_DATE('03/08/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2200, NULL, 120,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (129, 'Laura', 'Bissot', 'LBISSOT', '650.124.5234',
    TO_DATE('08/20/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 3300, NULL, 121,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (130, 'Mozhe', 'Atkinson', 'MATKINSO', '650.124.6234',
    TO_DATE('10/30/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2800, NULL, 121,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (131, 'James', 'Marlow', 'JAMRLOW', '650.124.7234',
    TO_DATE('02/16/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2500, NULL, 121,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (132, 'TJ', 'Olson', 'TJOLSON', '650.124.8234',
    TO_DATE('04/10/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2100, NULL, 121,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (133, 'Jason', 'Mallin', 'JMALLIN', '650.127.1934',
    TO_DATE('06/14/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 3300, NULL, 122,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (134, 'Michael', 'Rogers', 'MROGERS', '650.127.1834',
    TO_DATE('08/26/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2900, NULL, 122,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (135, 'Ki', 'Gee', 'KGEE', '650.127.1734',
    TO_DATE('12/12/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2400, NULL, 122,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (136, 'Hazel', 'Philtanker', 'HPHILTAN', '650.127.1634',
    TO_DATE('02/06/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2200, NULL, 122,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (137, 'Renske', 'Ladwig', 'RLADWIG', '650.121.1234',
    TO_DATE('07/14/1995 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 3600, NULL, 123,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (138, 'Stephen', 'Stiles', 'SSTILES', '650.121.2034',
    TO_DATE('10/26/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 3200, NULL, 123,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (139, 'John', 'Seo', 'JSEO', '650.121.2019',
    TO_DATE('02/12/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2700, NULL, 123,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (140, 'Joshua', 'Patel', 'JPATEL', '650.121.1834',
    TO_DATE('04/06/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2500, NULL, 123,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (141, 'Trenna', 'Rajs', 'TRAJS', '650.121.8009',
    TO_DATE('10/17/1995 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 3500, NULL, 124,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (142, 'Curtis', 'Davies', 'CDAVIES', '650.121.2994',
    TO_DATE('01/29/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 3100, NULL, 124,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (143, 'Randall', 'Matos', 'RMATOS', '650.121.2874',
    TO_DATE('03/15/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2600, NULL, 124,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (144, 'Peter', 'Vargas', 'PVARGAS', '650.121.2004',
    TO_DATE('07/09/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2500, NULL, 124,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (145, 'John', 'Russell', 'JRUSSEL', '011.44.1344.429268',
    TO_DATE('10/01/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_MAN', 14000, 0.4, 100,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (146, 'Karen', 'Partners', 'KPARTNER', '011.44.1344.467268',
    TO_DATE('01/05/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_MAN', 13500, 0.3, 100,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (147, 'Alberto', 'Errazuriz', 'AERRAZUR', '011.44.1344.429278',
    TO_DATE('03/10/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_MAN', 12000, 0.3, 100,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (148, 'Gerald', 'Cambrault', 'GCAMBRAU', '011.44.1344.619268',
    TO_DATE('10/15/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_MAN', 11000, 0.3, 100,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (149, 'Eleni', 'Zlotkey', 'EZLOTKEY', '011.44.1344.429018',
    TO_DATE('01/29/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_MAN', 10500, 0.2, 100,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (150, 'Peter', 'Tucker', 'PTUCKER', '011.44.1344.129268',
    TO_DATE('01/30/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 10000, 0.3, 145,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (151, 'David', 'Bernstein', 'DBERNSTE', '011.44.1344.345268',
    TO_DATE('03/24/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 9500, 0.25, 145,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (152, 'Peter', 'Hall', 'PHALL', '011.44.1344.478968',
    TO_DATE('08/20/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 9000, 0.25, 145,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (153, 'Christopher', 'Olsen', 'COLSEN', '011.44.1344.498718',
    TO_DATE('03/30/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 8000, 0.2, 145,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (154, 'Nanette', 'Cambrault', 'NCAMBRAU', '011.44.1344.987668',
    TO_DATE('12/09/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7500, 0.2, 145,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (155, 'Oliver', 'Tuvault', 'OTUVAULT', '011.44.1344.486508',
    TO_DATE('11/23/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7000, 0.15, 145,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (156, 'Janette', 'King', 'JKING', '011.44.1345.429268',
    TO_DATE('01/30/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 10000, 0.35, 146,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (157, 'Patrick', 'Sully', 'PSULLY', '011.44.1345.929268',
    TO_DATE('03/04/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 9500, 0.35, 146,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (158, 'Allan', 'McEwen', 'AMCEWEN', '011.44.1345.829268',
    TO_DATE('08/01/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 9000, 0.35, 146,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (159, 'Lindsey', 'Smith', 'LSMITH', '011.44.1345.729268',
    TO_DATE('03/10/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 8000, 0.3, 146,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (160, 'Louise', 'Doran', 'LDORAN', '011.44.1345.629268',
    TO_DATE('12/15/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7500, 0.3, 146,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (161, 'Sarath', 'Sewall', 'SSEWALL', '011.44.1345.529268',
    TO_DATE('11/03/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7000, 0.25, 146,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (162, 'Clara', 'Vishney', 'CVISHNEY', '011.44.1346.129268',
    TO_DATE('11/11/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 10500, 0.25, 147,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (163, 'Danielle', 'Greene', 'DGREENE', '011.44.1346.229268',
    TO_DATE('03/19/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 9500, 0.15, 147,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (164, 'Mattea', 'Marvins', 'MMARVINS', '011.44.1346.329268',
    TO_DATE('01/24/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7200, 0.1, 147,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (165, 'David', 'Lee', 'DLEE', '011.44.1346.529268',
    TO_DATE('02/23/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 6800, 0.1, 147,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (166, 'Sundar', 'Ande', 'SANDE', '011.44.1346.629268',
    TO_DATE('03/24/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 6400, 0.1, 147,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (167, 'Amit', 'Banda', 'ABANDA', '011.44.1346.729268',
    TO_DATE('04/21/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 6200, 0.1, 147,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (168, 'Lisa', 'Ozer', 'LOZER', '011.44.1343.929268',
    TO_DATE('03/11/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 11500, 0.25, 148,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (169, 'Harrison', 'Bloom', 'HBLOOM', '011.44.1343.829268',
    TO_DATE('03/23/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 10000, 0.2, 148,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (170, 'Tayler', 'Fox', 'TFOX', '011.44.1343.729268',
    TO_DATE('01/24/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 9600, 0.2, 148,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (171, 'William', 'Smith', 'WSMITH', '011.44.1343.629268',
    TO_DATE('02/23/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7400, 0.15, 148,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (172, 'Elizabeth', 'Bates', 'EBATES', '011.44.1343.529268',
    TO_DATE('03/24/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7300, 0.15, 148,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (173, 'Sundita', 'Kumar', 'SKUMAR', '011.44.1343.329268',
    TO_DATE('04/21/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 6100, 0.1, 148,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (174, 'Ellen', 'Abel', 'EABEL', '011.44.1644.429267',
    TO_DATE('05/11/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 11000, 0.3, 149,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (175, 'Alyssa', 'Hutton', 'AHUTTON', '011.44.1644.429266',
    TO_DATE('03/19/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 8800, 0.25, 149,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (176, 'Jonathon', 'Taylor', 'JTAYLOR', '011.44.1644.429265',
    TO_DATE('03/24/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 8600, 0.2, 149,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (177, 'Jack', 'Livingston', 'JLIVINGS', '011.44.1644.429264',
    TO_DATE('04/23/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 8400, 0.2, 149,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (178, 'Kimberely', 'Grant', 'KGRANT', '011.44.1644.429263',
    TO_DATE('05/24/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7000, 0.15, 149,
    NULL);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (179, 'Charles', 'Johnson', 'CJOHNSON', '011.44.1644.429262',
    TO_DATE('01/04/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 6200, 0.1, 149,
    80);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (180, 'Winston', 'Taylor', 'WTAYLOR', '650.507.9876',
    TO_DATE('01/24/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3200, NULL, 120,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (181, 'Jean', 'Fleaur', 'JFLEAUR', '650.507.9877',
    TO_DATE('02/23/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3100, NULL, 120,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (182, 'Martha', 'Sullivan', 'MSULLIVA', '650.507.9878',
    TO_DATE('06/21/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 2500, NULL, 120,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (183, 'Girard', 'Geoni', 'GGEONI', '650.507.9879',
    TO_DATE('02/03/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 2800, NULL, 120,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (184, 'Nandita', 'Sarchand', 'NSARCHAN', '650.509.1876',
    TO_DATE('01/27/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 4200, NULL, 121,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (185, 'Alexis', 'Bull', 'ABULL', '650.509.2876',
    TO_DATE('02/20/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 4100, NULL, 121,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (186, 'Julia', 'Dellinger', 'JDELLING', '650.509.3876',
    TO_DATE('06/24/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3400, NULL, 121,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (187, 'Anthony', 'Cabrio', 'ACABRIO', '650.509.4876',
    TO_DATE('02/07/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3000, NULL, 121,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (188, 'Kelly', 'Chung', 'KCHUNG', '650.505.1876',
    TO_DATE('06/14/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3800, NULL, 122,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (189, 'Jennifer', 'Dilly', 'JDILLY', '650.505.2876',
    TO_DATE('08/13/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3600, NULL, 122,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (190, 'Timothy', 'Gates', 'TGATES', '650.505.3876',
    TO_DATE('07/11/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 2900, NULL, 122,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (191, 'Randall', 'Perkins', 'RPERKINS', '650.505.4876',
    TO_DATE('12/19/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 2500, NULL, 122,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (192, 'Sarah', 'Bell', 'SBELL', '650.501.1876',
    TO_DATE('02/04/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 4000, NULL, 123,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (193, 'Britney', 'Everett', 'BEVERETT', '650.501.2876',
    TO_DATE('03/03/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3900, NULL, 123,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (194, 'Samuel', 'McCain', 'SMCCAIN', '650.501.3876',
    TO_DATE('07/01/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3200, NULL, 123,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (195, 'Vance', 'Jones', 'VJONES', '650.501.4876',
    TO_DATE('03/17/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 2800, NULL, 123,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (196, 'Alana', 'Walsh', 'AWALSH', '650.507.9811',
    TO_DATE('04/24/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3100, NULL, 124,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (197, 'Kevin', 'Feeney', 'KFEENEY', '650.507.9822',
    TO_DATE('05/23/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3000, NULL, 124,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (198, 'Donald', 'OConnell', 'DOCONNEL', '650.507.9833',
    TO_DATE('06/21/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 2600, NULL, 124,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (199, 'Douglas', 'Grant', 'DGRANT', '650.507.9844',
    TO_DATE('01/13/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 2600, NULL, 124,
    50);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (200, 'Jennifer', 'Whalen', 'JWHALEN', '515.123.4444',
    TO_DATE('09/17/1987 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AD_ASST', 4400, NULL, 101,
    10);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (201, 'Michael', 'Hartstein', 'MHARTSTE', '515.123.5555',
    TO_DATE('02/17/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MK_MAN', 13000, NULL, 100,
    20);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (202, 'Pat', 'Fay', 'PFAY', '603.123.6666',
    TO_DATE('08/17/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MK_REP', 6000, NULL, 201,
    20);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (203, 'Susan', 'Mavris', 'SMAVRIS', '515.123.7777',
    TO_DATE('06/07/1994 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'HR_REP', 6500, NULL, 101,
    40);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (204, 'Hermann', 'Baer', 'HBAER', '515.123.8888',
    TO_DATE('06/07/1994 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PR_REP', 10000, NULL, 101,
    70);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (205, 'Shelley', 'Higgins', 'SHIGGINS', '515.123.8080',
    TO_DATE('06/07/1994 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AC_MGR', 12000, NULL, 101,
    110);
Insert into HR.EMPLOYEES
   (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
    HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID,
    DEPARTMENT_ID)
 Values
   (206, 'William', 'Gietz', 'WGIETZ', '515.123.8181',
    TO_DATE('06/07/1994 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AC_ACCOUNT', 8300, NULL, 205,
    110);
COMMIT;

SET DEFINE OFF;
Insert into HR.JOB_HISTORY
   (EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMENT_ID)
 Values
   (102, TO_DATE('01/13/1993 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('07/24/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'IT_PROG', 60);
Insert into HR.JOB_HISTORY
   (EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMENT_ID)
 Values
   (101, TO_DATE('09/21/1989 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('10/27/1993 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AC_ACCOUNT', 110);
Insert into HR.JOB_HISTORY
   (EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMENT_ID)
 Values
   (101, TO_DATE('10/28/1993 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('03/15/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AC_MGR', 110);
Insert into HR.JOB_HISTORY
   (EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMENT_ID)
 Values
   (201, TO_DATE('02/17/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/19/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MK_REP', 20);
Insert into HR.JOB_HISTORY
   (EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMENT_ID)
 Values
   (114, TO_DATE('03/24/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/31/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 50);
Insert into HR.JOB_HISTORY
   (EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMENT_ID)
 Values
   (122, TO_DATE('01/01/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/31/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 50);
Insert into HR.JOB_HISTORY
   (EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMENT_ID)
 Values
   (200, TO_DATE('09/17/1987 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/17/1993 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AD_ASST', 90);
Insert into HR.JOB_HISTORY
   (EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMENT_ID)
 Values
   (176, TO_DATE('03/24/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/31/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 80);
Insert into HR.JOB_HISTORY
   (EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMENT_ID)
 Values
   (176, TO_DATE('01/01/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/31/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_MAN', 80);
Insert into HR.JOB_HISTORY
   (EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMENT_ID)
 Values
   (200, TO_DATE('07/01/1994 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/31/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AC_ACCOUNT', 90);
COMMIT;

SET DEFINE OFF;
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('AD_PRES', 'President', 20000, 40000);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('AD_VP', 'Administration Vice President', 15000, 30000);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('AD_ASST', 'Administration Assistant', 3000, 6000);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('FI_MGR', 'Finance Manager', 8200, 16000);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('FI_ACCOUNT', 'Accountant', 4200, 9000);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('AC_MGR', 'Accounting Manager', 8200, 16000);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('AC_ACCOUNT', 'Public Accountant', 4200, 9000);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('SA_MAN', 'Sales Manager', 10000, 20000);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('SA_REP', 'Sales Representative', 6000, 12000);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('PU_MAN', 'Purchasing Manager', 8000, 15000);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('PU_CLERK', 'Purchasing Clerk', 2500, 5500);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('ST_MAN', 'Stock Manager', 5500, 8500);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('ST_CLERK', 'Stock Clerk', 2000, 5000);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('SH_CLERK', 'Shipping Clerk', 2500, 5500);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('IT_PROG', 'Programmer', 4000, 10000);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('MK_MAN', 'Marketing Manager', 9000, 15000);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('MK_REP', 'Marketing Representative', 4000, 9000);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('HR_REP', 'Human Resources Representative', 4000, 9000);
Insert into HR.JOBS
   (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
 Values
   ('PR_REP', 'Public Relations Representative', 4500, 10500);
COMMIT;

SET DEFINE OFF;
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (1000, '1297 Via Cola di Rie', '00989', 'Roma', NULL,
    'IT');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (1100, '93091 Calle della Testa', '10934', 'Venice', NULL,
    'IT');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (1200, '2017 Shinjuku-ku', '1689', 'Tokyo', 'Tokyo Prefecture',
    'JP');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (1300, '9450 Kamiya-cho', '6823', 'Hiroshima', NULL,
    'JP');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (1400, '2014 Jabberwocky Rd', '26192', 'Southlake', 'Texas',
    'US');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (1500, '2011 Interiors Blvd', '99236', 'South San Francisco', 'California',
    'US');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (1600, '2007 Zagora St', '50090', 'South Brunswick', 'New Jersey',
    'US');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (1700, '2004 Charade Rd', '98199', 'Seattle', 'Washington',
    'US');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (1800, '147 Spadina Ave', 'M5V 2L7', 'Toronto', 'Ontario',
    'CA');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (1900, '6092 Boxwood St', 'YSW 9T2', 'Whitehorse', 'Yukon',
    'CA');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (2000, '40-5-12 Laogianggen', '190518', 'Beijing', NULL,
    'CN');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (2100, '1298 Vileparle (E)', '490231', 'Bombay', 'Maharashtra',
    'IN');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (2200, '12-98 Victoria Street', '2901', 'Sydney', 'New South Wales',
    'AU');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (2300, '198 Clementi North', '540198', 'Singapore', NULL,
    'SG');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (2400, '8204 Arthur St', NULL, 'London', NULL,
    'UK');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (2500, 'Magdalen Centre, The Oxford Science Park', 'OX9 9ZB', 'Oxford', 'Oxford',
    'UK');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (2600, '9702 Chester Road', '09629850293', 'Stretford', 'Manchester',
    'UK');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (2700, 'Schwanthalerstr. 7031', '80925', 'Munich', 'Bavaria',
    'DE');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (2800, 'Rua Frei Caneca 1360 ', '01307-002', 'Sao Paulo', 'Sao Paulo',
    'BR');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (2900, '20 Rue des Corps-Saints', '1730', 'Geneva', 'Geneve',
    'CH');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (3000, 'Murtenstrasse 921', '3095', 'Bern', 'BE',
    'CH');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (3100, 'Pieter Breughelstraat 837', '3029SK', 'Utrecht', 'Utrecht',
    'NL');
Insert into HR.LOCATIONS
   (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE,
    COUNTRY_ID)
 Values
   (3200, 'Mariano Escobedo 9991', '11932', 'Mexico City', 'Distrito Federal,',
    'MX');
COMMIT;

SET DEFINE OFF;
Insert into HR.REGIONS
   (REGION_ID, REGION_NAME)
 Values
   (1, 'Europe');
Insert into HR.REGIONS
   (REGION_ID, REGION_NAME)
 Values
   (2, 'Americas');
Insert into HR.REGIONS
   (REGION_ID, REGION_NAME)
 Values
   (3, 'Asia');
Insert into HR.REGIONS
   (REGION_ID, REGION_NAME)
 Values
   (4, 'Middle East and Africa');
COMMIT;


Continue Reading

Sunday, March 2, 2014

Posted by V. Kapoor
No comments | 11:30 PM
Suppose you want to check the user permissions on inserting or updating the records in Oracle Forms, then you can use Pre-Insert and Pre-Update triggers for that particular data block to check whether user is having proper permission or not.

The example is given for HR schema and the following demo table is created for this:

Create Table User_Permissions (User_Name varchar2(50) Primary Key,
Can_Insert Varchar2(1) default 'N',
Can_Update Varchar2(1) default 'N')

Insert into User_Permissions values ('FORMUSER1', 'Y', 'N');

Commit;

Below is the screen shot for the examle:


You can download this form from the following link: Pre-Update-Insert.fmb

The following is the code written in Pre-Update trigger to check the permissions from the database:

Declare
n_allow number;
begin
Select 1 into n_allow
  from hr.user_permissions
  where user_name = 'FORMUSER1'
  and can_update = 'Y';
  --- all is well if no exception raised else stop in exception area
  exception
  when others then
     message('You have no permission to update the record.');
     message('You have no permission to update the record.');
     raise form_trigger_failure;
end;

The following is the code written in Pre-Insert trigger to check the permissions from the database on Insert:

Declare
n_allow number;
begin
Select 1 into n_allow
  from hr.user_permissions
  where user_name = 'FORMUSER1'
  and can_insert = 'Y';
  --- all is well if no exception raised else stop in exception area

  exception
  when others then
     message('You have no permission to insert the record.');
     message('You have no permission to insert the record.');
     raise form_trigger_failure;
   
end;

The code is written for Save button:

Commit_form;


Continue Reading

Blog Archive

Fox Infotech. Powered by Blogger.

Subscribers

Translate

Payment Gateway