Oracle Live SQL - Script: Flashback Versions Query and Pseudo Last Date Changed column

Statement 1

begin  
   dbms_output.put_line('Copyright (c) 2018, Oracle and/or its affiliates.  All rights reserved.  '); 
   dbms_output.put_line('Permission is hereby granted, free of charge, to any person obtaining '); 
   dbms_output.put_line('a copy of this software and associated documentation files (the '); 
   dbms_output.put_line('"Software"), to deal in the Software without restriction, including '); 
   dbms_output.put_line('without limitation the rights to use, copy, modify, merge, publish, '); 
   dbms_output.put_line('distribute, sublicense, and/or sell copies of the Software, and to '); 
   dbms_output.put_line('permit persons to whom the Software is furnished to do so, subject to '); 
   dbms_output.put_line('the following conditions: '); 
   dbms_output.put_line(' '); 
   dbms_output.put_line('The above copyright notice and this permission notice shall be '); 
   dbms_output.put_line('included in all copies or substantial portions of the Software. '); 
   dbms_output.put_line(' '); 
   dbms_output.put_line('THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, '); 
   dbms_output.put_line('EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF '); 
   dbms_output.put_line('MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND '); 
   dbms_output.put_line('NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE '); 
   dbms_output.put_line('LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION '); 
   dbms_output.put_line('OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION '); 
   dbms_output.put_line('WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. '); 
end;

Statement processed.
Copyright (c) 2018, Oracle and/or its affiliates. All rights reserved.
Permission is hereby granted, free of charge, to any person obtaining
a copy of this software and associated documentation files (the
"Software"), to deal in the Software without restriction, including
without limitation the rights to use, copy, modify, merge, publish,
distribute, sublicense, and/or sell copies of the Software, and to
permit persons to whom the Software is furnished to do so, subject to
the following conditions:
The above copyright notice and this permission notice shall be
included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Statement 2

CREATE TABLE regions  
    ( region_id      NUMBER   
                     CONSTRAINT region_id_nn NOT NULL 
    ,                CONSTRAINT reg_id_pk  
                        PRIMARY KEY (region_id) 
    , region_name    VARCHAR2(25)   
    )

Table created.

Statement 3

CREATE TABLE countries   
    ( country_id      CHAR(2)   
                      CONSTRAINT country_id_nn NOT NULL 
    ,                 CONSTRAINT country_c_id_pk   
        	         PRIMARY KEY (country_id) 
    , country_name    VARCHAR2(40)   
    , region_id       NUMBER   
    ,                 CONSTRAINT countr_reg_fk  
        	         FOREIGN KEY (region_id)  
          	         REFERENCES regions (region_id)   
    )   
    ORGANIZATION INDEX

Table created.

Statement 4

CREATE TABLE locations  
    ( location_id    NUMBER(4)  NOT NULL 
                     CONSTRAINT loc_id_pk  
       		        PRIMARY KEY  
    , street_address VARCHAR2(40)  
    , postal_code    VARCHAR2(12)  
    , city           VARCHAR2(30)  
	             CONSTRAINT loc_city_nn  NOT NULL  
    , state_province VARCHAR2(25)  
    , country_id     CHAR(2)  
    ,                CONSTRAINT loc_c_id_fk  
       		        FOREIGN KEY (country_id)  
        	        REFERENCES countries(country_id) 
    )

Table created.

Statement 5

CREATE SEQUENCE locations_seq  
 START WITH     3300  
 INCREMENT BY   100  
 MAXVALUE       9900  
 NOCACHE  
 NOCYCLE

Sequence created.

Statement 6

CREATE TABLE departments  
    ( department_id    NUMBER(4) 
                       CONSTRAINT dept_id_pk  
       		          PRIMARY KEY 
    , department_name  VARCHAR2(30)  
	               CONSTRAINT dept_name_nn  NOT NULL  
    , manager_id       NUMBER(6)  
    , location_id      NUMBER(4)  
    ,                  CONSTRAINT dept_loc_fk  
       		          FOREIGN KEY (location_id)  
        	          REFERENCES locations (location_id)  
    )

Table created.

Statement 7

CREATE SEQUENCE departments_seq  
 START WITH     280  
 INCREMENT BY   10  
 MAXVALUE       9990  
 NOCACHE  
 NOCYCLE

Sequence created.

Statement 8

CREATE TABLE jobs  
    ( job_id         VARCHAR2(10)  
                     CONSTRAINT job_id_pk  
      		        PRIMARY KEY 
    , job_title      VARCHAR2(35)  
	             CONSTRAINT job_title_nn  NOT NULL  
    , min_salary     NUMBER(6)  
    , max_salary     NUMBER(6)  
    )

Table created.

Statement 9

CREATE TABLE employees  
    ( employee_id    NUMBER(6)  
                     CONSTRAINT emp_emp_id_pk  
                        PRIMARY KEY 
    , first_name     VARCHAR2(20)  
    , last_name      VARCHAR2(25)  
	             CONSTRAINT emp_last_name_nn  NOT NULL  
    , email          VARCHAR2(25)  
	             CONSTRAINT emp_email_nn  NOT NULL  
    , CONSTRAINT     emp_email_uk  
                     UNIQUE (email)  
    , phone_number   VARCHAR2(20)  
    , hire_date      DATE  
	             CONSTRAINT emp_hire_date_nn  NOT NULL  
    , job_id         VARCHAR2(10)  
	             CONSTRAINT emp_job_nn  NOT NULL  
    , salary         NUMBER(8,2)  
                     CONSTRAINT emp_salary_min  
                        CHECK (salary > 0)  
    , commission_pct NUMBER(2,2)  
    , manager_id     NUMBER(6)  
    ,                CONSTRAINT emp_manager_fk  
                        FOREIGN KEY (manager_id)  
                        REFERENCES employees 
    , department_id  NUMBER(4)  
    ,                CONSTRAINT emp_dept_fk  
                        FOREIGN KEY (department_id)  
                        REFERENCES departments 
    )

Table created.

Statement 10

ALTER TABLE departments  
   ADD (CONSTRAINT dept_mgr_fk  
      	FOREIGN KEY (manager_id)  
      	REFERENCES employees (employee_id)  
    )

Table altered.

Statement 11

CREATE SEQUENCE employees_seq  
 START WITH     207  
 INCREMENT BY   1  
 NOCACHE  
 NOCYCLE

Sequence created.

Statement 12

CREATE TABLE job_history  
    ( employee_id   NUMBER(6)  
	            CONSTRAINT jhist_employee_nn  NOT NULL  
    ,               CONSTRAINT jhist_emp_fk  
                       FOREIGN KEY (employee_id)  
                       REFERENCES employees  
    , start_date    DATE  
	            CONSTRAINT jhist_start_date_nn  NOT NULL  
    , end_date      DATE  
	            CONSTRAINT jhist_end_date_nn  NOT NULL  
    , job_id        VARCHAR2(10)  
	            CONSTRAINT jhist_job_nn  NOT NULL  
    ,               CONSTRAINT jhist_job_fk  
                       FOREIGN KEY (job_id)  
                       REFERENCES jobs  
    , department_id NUMBER(4)  
    ,               CONSTRAINT jhist_dept_fk  
                       FOREIGN KEY (department_id)  
                       REFERENCES departments 
    , CONSTRAINT    jhist_emp_id_st_date_pk  
                       PRIMARY KEY (employee_id, start_date) 
    , CONSTRAINT    jhist_date_interval  
                       CHECK (end_date > start_date)  
    )

Table created.

Statement 13

CREATE OR REPLACE VIEW emp_details_view  
  (employee_id,  
   job_id,  
   manager_id,  
   department_id,  
   location_id,  
   country_id,  
   first_name,  
   last_name,  
   salary,  
   commission_pct,  
   department_name,  
   job_title,  
   city,  
   state_province,  
   country_name,  
   region_name)  
AS SELECT  
  e.employee_id,   
  e.job_id,   
  e.manager_id,   
  e.department_id,  
  d.location_id,  
  l.country_id,  
  e.first_name,  
  e.last_name,  
  e.salary,  
  e.commission_pct,  
  d.department_name,  
  j.job_title,  
  l.city,  
  l.state_province,  
  c.country_name,  
  r.region_name  
FROM  
  employees e,  
  departments d,  
  jobs j,  
  locations l,  
  countries c,  
  regions r  
WHERE e.department_id = d.department_id  
  AND d.location_id = l.location_id  
  AND l.country_id = c.country_id  
  AND c.region_id = r.region_id  
  AND j.job_id = e.job_id   
WITH READ ONLY

View created.

Statement 14

BEGIN  
INSERT INTO regions VALUES   
        ( 1  
        , 'Europe'   
        );  
  
INSERT INTO regions VALUES   
        ( 2  
        , 'Americas'   
        );  
  
INSERT INTO regions VALUES   
        ( 3  
        , 'Asia'   
        );  
  
INSERT INTO regions VALUES   
        ( 4  
        , 'Middle East and Africa'   
        );  
END;

Statement processed.

Statement 15

BEGIN  
INSERT INTO countries VALUES   
        ( 'IT'  
        , 'Italy'  
        , 1   
        );  
  
INSERT INTO countries VALUES   
        ( 'JP'  
        , 'Japan'  
	, 3   
        );  
  
INSERT INTO countries VALUES   
        ( 'US'  
        , 'United States of America'  
        , 2   
        );  
  
INSERT INTO countries VALUES   
        ( 'CA'  
        , 'Canada'  
        , 2   
        );  
  
INSERT INTO countries VALUES   
        ( 'CN'  
        , 'China'  
        , 3   
        );  
  
INSERT INTO countries VALUES   
        ( 'IN'  
        , 'India'  
        , 3   
        );  
  
INSERT INTO countries VALUES   
        ( 'AU'  
        , 'Australia'  
        , 3   
        );  
  
INSERT INTO countries VALUES   
        ( 'ZW'  
        , 'Zimbabwe'  
        , 4   
        );  
  
INSERT INTO countries VALUES   
        ( 'SG'  
        , 'Singapore'  
        , 3   
        );  
  
INSERT INTO countries VALUES   
        ( 'UK'  
        , 'United Kingdom'  
        , 1   
        );  
  
INSERT INTO countries VALUES   
        ( 'FR'  
        , 'France'  
        , 1   
        );  
  
INSERT INTO countries VALUES   
        ( 'DE'  
        , 'Germany'  
        , 1   
        );  
  
INSERT INTO countries VALUES   
        ( 'ZM'  
        , 'Zambia'  
        , 4   
        );  
  
INSERT INTO countries VALUES   
        ( 'EG'  
        , 'Egypt'  
        , 4   
        );  
  
INSERT INTO countries VALUES   
        ( 'BR'  
        , 'Brazil'  
        , 2   
        );  
  
INSERT INTO countries VALUES   
        ( 'CH'  
        , 'Switzerland'  
        , 1   
        );  
  
INSERT INTO countries VALUES   
        ( 'NL'  
        , 'Netherlands'  
        , 1   
        );  
  
INSERT INTO countries VALUES   
        ( 'MX'  
        , 'Mexico'  
        , 2   
        );  
  
INSERT INTO countries VALUES   
        ( 'KW'  
        , 'Kuwait'  
        , 4   
        );  
  
INSERT INTO countries VALUES   
        ( 'IL'  
        , 'Israel'  
        , 4   
        );  
  
INSERT INTO countries VALUES   
        ( 'DK'  
        , 'Denmark'  
        , 1   
        );  
  
INSERT INTO countries VALUES   
        ( 'ML'  
        , 'Malaysia'  
        , 3   
        );  
  
INSERT INTO countries VALUES   
        ( 'NG'  
        , 'Nigeria'  
        , 4   
        );  
  
INSERT INTO countries VALUES   
        ( 'AR'  
        , 'Argentina'  
        , 2   
        );  
  
INSERT INTO countries VALUES   
        ( 'BE'  
        , 'Belgium'  
        , 1   
        );  
END;

Statement processed.

Statement 16

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

Statement processed.

Statement 17

ALTER TABLE departments   
  DISABLE CONSTRAINT dept_mgr_fk

Table altered.

Statement 18

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

Statement processed.

Statement 19

BEGIN  
INSERT INTO jobs VALUES   
        ( 'AD_PRES'  
        , 'President'  
        , 20080  
        , 40000  
        );  
INSERT INTO jobs VALUES   
        ( 'AD_VP'  
        , 'Administration Vice President'  
        , 15000  
        , 30000  
        );  
  
INSERT INTO jobs VALUES   
        ( 'AD_ASST'  
        , 'Administration Assistant'  
        , 3000  
        , 6000  
        );  
  
INSERT INTO jobs VALUES   
        ( 'FI_MGR'  
        , 'Finance Manager'  
        , 8200  
        , 16000  
        );  
  
INSERT INTO jobs VALUES   
        ( 'FI_ACCOUNT'  
        , 'Accountant'  
        , 4200  
        , 9000  
        );  
  
INSERT INTO jobs VALUES   
        ( 'AC_MGR'  
        , 'Accounting Manager'  
        , 8200  
        , 16000  
        );  
  
INSERT INTO jobs VALUES   
        ( 'AC_ACCOUNT'  
        , 'Public Accountant'  
        , 4200  
        , 9000  
        );  
INSERT INTO jobs VALUES   
        ( 'SA_MAN'  
        , 'Sales Manager'  
        , 10000  
        , 20080  
        );  
  
INSERT INTO jobs VALUES   
        ( 'SA_REP'  
        , 'Sales Representative'  
        , 6000  
        , 12008  
        );  
  
INSERT INTO jobs VALUES   
        ( 'PU_MAN'  
        , 'Purchasing Manager'  
        , 8000  
        , 15000  
        );  
  
INSERT INTO jobs VALUES   
        ( 'PU_CLERK'  
        , 'Purchasing Clerk'  
        , 2500  
        , 5500  
        );  
  
INSERT INTO jobs VALUES   
        ( 'ST_MAN'  
        , 'Stock Manager'  
        , 5500  
        , 8500  
        );  
INSERT INTO jobs VALUES   
        ( 'ST_CLERK'  
        , 'Stock Clerk'  
        , 2008  
        , 5000  
        );  
  
INSERT INTO jobs VALUES   
        ( 'SH_CLERK'  
        , 'Shipping Clerk'  
        , 2500  
        , 5500  
        );  
  
INSERT INTO jobs VALUES   
        ( 'IT_PROG'  
        , 'Programmer'  
        , 4000  
        , 10000  
        );  
  
INSERT INTO jobs VALUES   
        ( 'MK_MAN'  
        , 'Marketing Manager'  
        , 9000  
        , 15000  
        );  
  
INSERT INTO jobs VALUES   
        ( 'MK_REP'  
        , 'Marketing Representative'  
        , 4000  
        , 9000  
        );  
  
INSERT INTO jobs VALUES   
        ( 'HR_REP'  
        , 'Human Resources Representative'  
        , 4000  
        , 9000  
        );  
  
INSERT INTO jobs VALUES   
        ( 'PR_REP'  
        , 'Public Relations Representative'  
        , 4500  
        , 10500  
        );  
END;

Statement processed.

Statement 20

BEGIN    
INSERT INTO employees VALUES     
        ( 100    
        , 'Steven'    
        , 'King'    
        , 'SKING'    
        , '515.123.4567'    
        , TO_DATE('17-06-2003', 'dd-MM-yyyy')    
        , 'AD_PRES'    
        , 24000    
        , NULL    
        , NULL    
        , 90    
        );    
    
INSERT INTO employees VALUES     
        ( 101    
        , 'Neena'    
        , 'Kochhar'    
        , 'NKOCHHAR'    
        , '515.123.4568'    
        , TO_DATE('21-09-2005', 'dd-MM-yyyy')    
        , 'AD_VP'    
        , 17000    
        , NULL    
        , 100    
        , 90    
        );    
    
INSERT INTO employees VALUES     
        ( 102    
        , 'Lex'    
        , 'De Haan'    
        , 'LDEHAAN'    
        , '515.123.4569'    
        , TO_DATE('13-01-2001', 'dd-MM-yyyy')    
        , 'AD_VP'    
        , 17000    
        , NULL    
        , 100    
        , 90    
        );    
    
INSERT INTO employees VALUES     
        ( 103    
        , 'Alexander'    
        , 'Hunold'    
        , 'AHUNOLD'    
        , '590.423.4567'    
        , TO_DATE('03-01-2006', 'dd-MM-yyyy')    
        , 'IT_PROG'    
        , 9000    
        , NULL    
        , 102    
        , 60    
        );    
    
INSERT INTO employees VALUES     
        ( 104    
        , 'Bruce'    
        , 'Ernst'    
        , 'BERNST'    
        , '590.423.4568'    
        , TO_DATE('21-05-2007', 'dd-MM-yyyy')    
        , 'IT_PROG'    
        , 6000    
        , NULL    
        , 103    
        , 60    
        );    
    
INSERT INTO employees VALUES     
        ( 105    
        , 'David'    
        , 'Austin'    
        , 'DAUSTIN'    
        , '590.423.4569'    
        , TO_DATE('25-06-2005', 'dd-MM-yyyy')    
        , 'IT_PROG'    
        , 4800    
        , NULL    
        , 103    
        , 60    
        );    
    
INSERT INTO employees VALUES     
        ( 106    
        , 'Valli'    
        , 'Pataballa'    
        , 'VPATABAL'    
        , '590.423.4560'    
        , TO_DATE('05-02-2006', 'dd-MM-yyyy')    
        , 'IT_PROG'    
        , 4800    
        , NULL    
        , 103    
        , 60    
        );    
    
INSERT INTO employees VALUES     
        ( 107    
        , 'Diana'    
        , 'Lorentz'    
        , 'DLORENTZ'    
        , '590.423.5567'    
        , TO_DATE('07-02-2007', 'dd-MM-yyyy')    
        , 'IT_PROG'    
        , 4200    
        , NULL    
        , 103    
        , 60    
        );    
    
INSERT INTO employees VALUES     
        ( 108    
        , 'Nancy'    
        , 'Greenberg'    
        , 'NGREENBE'    
        , '515.124.4569'    
        , TO_DATE('17-08-2002', 'dd-MM-yyyy')    
        , 'FI_MGR'    
        , 12008    
        , NULL    
        , 101    
        , 100    
        );    
    
INSERT INTO employees VALUES     
        ( 109    
        , 'Daniel'    
        , 'Faviet'    
        , 'DFAVIET'    
        , '515.124.4169'    
        , TO_DATE('16-08-2002', 'dd-MM-yyyy')    
        , 'FI_ACCOUNT'    
        , 9000    
        , NULL    
        , 108    
        , 100    
        );    
    
INSERT INTO employees VALUES     
        ( 110    
        , 'John'    
        , 'Chen'    
        , 'JCHEN'    
        , '515.124.4269'    
        , TO_DATE('28-09-2005', 'dd-MM-yyyy')    
        , 'FI_ACCOUNT'    
        , 8200    
        , NULL    
        , 108    
        , 100    
        );    
    
INSERT INTO employees VALUES     
        ( 111    
        , 'Ismael'    
        , 'Sciarra'    
        , 'ISCIARRA'    
        , '515.124.4369'    
        , TO_DATE('30-09-2005', 'dd-MM-yyyy')    
        , 'FI_ACCOUNT'    
        , 7700    
        , NULL    
        , 108    
        , 100    
        );    
    
INSERT INTO employees VALUES     
        ( 112    
        , 'Jose Manuel'    
        , 'Urman'    
        , 'JMURMAN'    
        , '515.124.4469'    
        , TO_DATE('07-03-2006', 'dd-MM-yyyy')    
        , 'FI_ACCOUNT'    
        , 7800    
        , NULL    
        , 108    
        , 100    
        );    
    
INSERT INTO employees VALUES     
        ( 113    
        , 'Luis'    
        , 'Popp'    
        , 'LPOPP'    
        , '515.124.4567'    
        , TO_DATE('07-12-2007', 'dd-MM-yyyy')    
        , 'FI_ACCOUNT'    
        , 6900    
        , NULL    
        , 108    
        , 100    
        );    
    
INSERT INTO employees VALUES     
        ( 114    
        , 'Den'    
        , 'Raphaely'    
        , 'DRAPHEAL'    
        , '515.127.4561'    
        , TO_DATE('07-12-2002', 'dd-MM-yyyy')    
        , 'PU_MAN'    
        , 11000    
        , NULL    
        , 100    
        , 30    
        );    
    
INSERT INTO employees VALUES     
        ( 115    
        , 'Alexander'    
        , 'Khoo'    
        , 'AKHOO'    
        , '515.127.4562'    
        , TO_DATE('18-05-2003', 'dd-MM-yyyy')    
        , 'PU_CLERK'    
        , 3100    
        , NULL    
        , 114    
        , 30    
        );    
    
INSERT INTO employees VALUES     
        ( 116    
        , 'Shelli'    
        , 'Baida'    
        , 'SBAIDA'    
        , '515.127.4563'    
        , TO_DATE('24-12-2005', 'dd-MM-yyyy')    
        , 'PU_CLERK'    
        , 2900    
        , NULL    
        , 114    
        , 30    
        );    
    
INSERT INTO employees VALUES     
        ( 117    
        , 'Sigal'    
        , 'Tobias'    
        , 'STOBIAS'    
        , '515.127.4564'    
        , TO_DATE('24-07-2005', 'dd-MM-yyyy')    
        , 'PU_CLERK'    
        , 2800    
        , NULL    
        , 114    
        , 30    
        );    
    
INSERT INTO employees VALUES     
        ( 118    
        , 'Guy'    
        , 'Himuro'    
        , 'GHIMURO'    
        , '515.127.4565'    
        , TO_DATE('15-11-2006', 'dd-MM-yyyy')    
        , 'PU_CLERK'    
        , 2600    
        , NULL    
        , 114    
        , 30    
        );    
    
INSERT INTO employees VALUES     
        ( 119    
        , 'Karen'    
        , 'Colmenares'    
        , 'KCOLMENA'    
        , '515.127.4566'    
        , TO_DATE('10-08-2007', 'dd-MM-yyyy')    
        , 'PU_CLERK'    
        , 2500    
        , NULL    
        , 114    
        , 30    
        );    
END;

Statement processed.

Statement 21

begin 
INSERT INTO employees VALUES     
        ( 120    
        , 'Matthew'    
        , 'Weiss'    
        , 'MWEISS'    
        , '650.123.1234'    
        , TO_DATE('18-07-2004', 'dd-MM-yyyy')    
        , 'ST_MAN'    
        , 8000    
        , NULL    
        , 100    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 121    
        , 'Adam'    
        , 'Fripp'    
        , 'AFRIPP'    
        , '650.123.2234'    
        , TO_DATE('10-04-2005', 'dd-MM-yyyy')    
        , 'ST_MAN'    
        , 8200    
        , NULL    
        , 100    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 122    
        , 'Payam'    
        , 'Kaufling'    
        , 'PKAUFLIN'    
        , '650.123.3234'    
        , TO_DATE('01-05-2003', 'dd-MM-yyyy')    
        , 'ST_MAN'    
        , 7900    
        , NULL    
        , 100    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 123    
        , 'Shanta'    
        , 'Vollman'    
        , 'SVOLLMAN'    
        , '650.123.4234'    
        , TO_DATE('10-10-2005', 'dd-MM-yyyy')    
        , 'ST_MAN'    
        , 6500    
        , NULL    
        , 100    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 124    
        , 'Kevin'    
        , 'Mourgos'    
        , 'KMOURGOS'    
        , '650.123.5234'    
        , TO_DATE('16-11-2007', 'dd-MM-yyyy')    
        , 'ST_MAN'    
        , 5800    
        , NULL    
        , 100    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 125    
        , 'Julia'    
        , 'Nayer'    
        , 'JNAYER'    
        , '650.124.1214'    
        , TO_DATE('16-07-2005', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 3200    
        , NULL    
        , 120    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 126    
        , 'Irene'    
        , 'Mikkilineni'    
        , 'IMIKKILI'    
        , '650.124.1224'    
        , TO_DATE('28-09-2006', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 2700    
        , NULL    
        , 120    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 127    
        , 'James'    
        , 'Landry'    
        , 'JLANDRY'    
        , '650.124.1334'    
        , TO_DATE('14-01-2007', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 2400    
        , NULL    
        , 120    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 128    
        , 'Steven'    
        , 'Markle'    
        , 'SMARKLE'    
        , '650.124.1434'    
        , TO_DATE('08-03-2008', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 2200    
        , NULL    
        , 120    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 129    
        , 'Laura'    
        , 'Bissot'    
        , 'LBISSOT'    
        , '650.124.5234'    
        , TO_DATE('20-08-2005', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 3300    
        , NULL    
        , 121    
        , 50    
        );    
END;

Statement processed.

Statement 22

begin  
INSERT INTO employees VALUES     
        ( 130    
        , 'Mozhe'    
        , 'Atkinson'    
        , 'MATKINSO'    
        , '650.124.6234'    
        , TO_DATE('30-10-2005', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 2800    
        , NULL    
        , 121    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 131    
        , 'James'    
        , 'Marlow'    
        , 'JAMRLOW'    
        , '650.124.7234'    
        , TO_DATE('16-02-2005', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 2500    
        , NULL    
        , 121    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 132    
        , 'TJ'    
        , 'Olson'    
        , 'TJOLSON'    
        , '650.124.8234'    
        , TO_DATE('10-04-2007', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 2100    
        , NULL    
        , 121    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 133    
        , 'Jason'    
        , 'Mallin'    
        , 'JMALLIN'    
        , '650.127.1934'    
        , TO_DATE('14-06-2004', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 3300    
        , NULL    
        , 122    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 134    
        , 'Michael'    
        , 'Rogers'    
        , 'MROGERS'    
        , '650.127.1834'    
        , TO_DATE('26-08-2006', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 2900    
        , NULL    
        , 122    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 135    
        , 'Ki'    
        , 'Gee'    
        , 'KGEE'    
        , '650.127.1734'    
        , TO_DATE('12-12-2007', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 2400    
        , NULL    
        , 122    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 136    
        , 'Hazel'    
        , 'Philtanker'    
        , 'HPHILTAN'    
        , '650.127.1634'    
        , TO_DATE('06-02-2008', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 2200    
        , NULL    
        , 122    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 137    
        , 'Renske'    
        , 'Ladwig'    
        , 'RLADWIG'    
        , '650.121.1234'    
        , TO_DATE('14-07-2003', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 3600    
        , NULL    
        , 123    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 138    
        , 'Stephen'    
        , 'Stiles'    
        , 'SSTILES'    
        , '650.121.2034'    
        , TO_DATE('26-10-2005', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 3200    
        , NULL    
        , 123    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 139    
        , 'John'    
        , 'Seo'    
        , 'JSEO'    
        , '650.121.2019'    
        , TO_DATE('12-02-2006', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 2700    
        , NULL    
        , 123    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 140    
        , 'Joshua'    
        , 'Patel'    
        , 'JPATEL'    
        , '650.121.1834'    
        , TO_DATE('06-04-2006', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 2500    
        , NULL    
        , 123    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 141    
        , 'Trenna'    
        , 'Rajs'    
        , 'TRAJS'    
        , '650.121.8009'    
        , TO_DATE('17-10-2003', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 3500    
        , NULL    
        , 124    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 142    
        , 'Curtis'    
        , 'Davies'    
        , 'CDAVIES'    
        , '650.121.2994'    
        , TO_DATE('29-01-2005', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 3100    
        , NULL    
        , 124    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 143    
        , 'Randall'    
        , 'Matos'    
        , 'RMATOS'    
        , '650.121.2874'    
        , TO_DATE('15-03-2006', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 2600    
        , NULL    
        , 124    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 144    
        , 'Peter'    
        , 'Vargas'    
        , 'PVARGAS'    
        , '650.121.2004'    
        , TO_DATE('09-07-2006', 'dd-MM-yyyy')    
        , 'ST_CLERK'    
        , 2500    
        , NULL    
        , 124    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 145    
        , 'John'    
        , 'Russell'    
        , 'JRUSSEL'    
        , '011.44.1344.429268'    
        , TO_DATE('01-10-2004', 'dd-MM-yyyy')    
        , 'SA_MAN'    
        , 14000    
        , .4    
        , 100    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 146    
        , 'Karen'    
        , 'Partners'    
        , 'KPARTNER'    
        , '011.44.1344.467268'    
        , TO_DATE('05-01-2005', 'dd-MM-yyyy')    
        , 'SA_MAN'    
        , 13500    
        , .3    
        , 100    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 147    
        , 'Alberto'    
        , 'Errazuriz'    
        , 'AERRAZUR'    
        , '011.44.1344.429278'    
        , TO_DATE('10-03-2005', 'dd-MM-yyyy')    
        , 'SA_MAN'    
        , 12000    
        , .3    
        , 100    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 148    
        , 'Gerald'    
        , 'Cambrault'    
        , 'GCAMBRAU'    
        , '011.44.1344.619268'    
        , TO_DATE('15-10-2007', 'dd-MM-yyyy')    
        , 'SA_MAN'    
        , 11000    
        , .3    
        , 100    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 149    
        , 'Eleni'    
        , 'Zlotkey'    
        , 'EZLOTKEY'    
        , '011.44.1344.429018'    
        , TO_DATE('29-01-2008', 'dd-MM-yyyy')    
        , 'SA_MAN'    
        , 10500    
        , .2    
        , 100    
        , 80    
        );    
end;

Statement processed.

Statement 23

begin 
INSERT INTO employees VALUES     
        ( 150    
        , 'Peter'    
        , 'Tucker'    
        , 'PTUCKER'    
        , '011.44.1344.129268'    
        , TO_DATE('30-01-2005', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 10000    
        , .3    
        , 145    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 151    
        , 'David'    
        , 'Bernstein'    
        , 'DBERNSTE'    
        , '011.44.1344.345268'    
        , TO_DATE('24-03-2005', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 9500    
        , .25    
        , 145    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 152    
        , 'Peter'    
        , 'Hall'    
        , 'PHALL'    
        , '011.44.1344.478968'    
        , TO_DATE('20-08-2005', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 9000    
        , .25    
        , 145    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 153    
        , 'Christopher'    
        , 'Olsen'    
        , 'COLSEN'    
        , '011.44.1344.498718'    
        , TO_DATE('30-03-2006', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 8000    
        , .2    
        , 145    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 154    
        , 'Nanette'    
        , 'Cambrault'    
        , 'NCAMBRAU'    
        , '011.44.1344.987668'    
        , TO_DATE('09-12-2006', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 7500    
        , .2    
        , 145    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 155    
        , 'Oliver'    
        , 'Tuvault'    
        , 'OTUVAULT'    
        , '011.44.1344.486508'    
        , TO_DATE('23-11-2007', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 7000    
        , .15    
        , 145    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 156    
        , 'Janette'    
        , 'King'    
        , 'JKING'    
        , '011.44.1345.429268'    
        , TO_DATE('30-01-2004', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 10000    
        , .35    
        , 146    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 157    
        , 'Patrick'    
        , 'Sully'    
        , 'PSULLY'    
        , '011.44.1345.929268'    
        , TO_DATE('04-03-2004', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 9500    
        , .35    
        , 146    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 158    
        , 'Allan'    
        , 'McEwen'    
        , 'AMCEWEN'    
        , '011.44.1345.829268'    
        , TO_DATE('01-08-2004', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 9000    
        , .35    
        , 146    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 159    
        , 'Lindsey'    
        , 'Smith'    
        , 'LSMITH'    
        , '011.44.1345.729268'    
        , TO_DATE('10-03-2005', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 8000    
        , .3    
        , 146    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 160    
        , 'Louise'    
        , 'Doran'    
        , 'LDORAN'    
        , '011.44.1345.629268'    
        , TO_DATE('15-12-2005', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 7500    
        , .3    
        , 146    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 161    
        , 'Sarath'    
        , 'Sewall'    
        , 'SSEWALL'    
        , '011.44.1345.529268'    
        , TO_DATE('03-11-2006', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 7000    
        , .25    
        , 146    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 162    
        , 'Clara'    
        , 'Vishney'    
        , 'CVISHNEY'    
        , '011.44.1346.129268'    
        , TO_DATE('11-11-2005', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 10500    
        , .25    
        , 147    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 163    
        , 'Danielle'    
        , 'Greene'    
        , 'DGREENE'    
        , '011.44.1346.229268'    
        , TO_DATE('19-03-2007', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 9500    
        , .15    
        , 147    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 164    
        , 'Mattea'    
        , 'Marvins'    
        , 'MMARVINS'    
        , '011.44.1346.329268'    
        , TO_DATE('24-01-2008', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 7200    
        , .10    
        , 147    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 165    
        , 'David'    
        , 'Lee'    
        , 'DLEE'    
        , '011.44.1346.529268'    
        , TO_DATE('23-02-2008', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 6800    
        , .1    
        , 147    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 166    
        , 'Sundar'    
        , 'Ande'    
        , 'SANDE'    
        , '011.44.1346.629268'    
        , TO_DATE('24-03-2008', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 6400    
        , .10    
        , 147    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 167    
        , 'Amit'    
        , 'Banda'    
        , 'ABANDA'    
        , '011.44.1346.729268'    
        , TO_DATE('21-04-2008', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 6200    
        , .10    
        , 147    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 168    
        , 'Lisa'    
        , 'Ozer'    
        , 'LOZER'    
        , '011.44.1343.929268'    
        , TO_DATE('11-03-2005', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 11500    
        , .25    
        , 148    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 169      
        , 'Harrison'    
        , 'Bloom'    
        , 'HBLOOM'    
        , '011.44.1343.829268'    
        , TO_DATE('23-03-2006', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 10000    
        , .20    
        , 148    
        , 80    
        );    
end;

Statement processed.

Statement 24

begin  
INSERT INTO employees VALUES     
        ( 170    
        , 'Tayler'    
        , 'Fox'    
        , 'TFOX'    
        , '011.44.1343.729268'    
        , TO_DATE('24-01-2006', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 9600    
        , .20    
        , 148    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 171    
        , 'William'    
        , 'Smith'    
        , 'WSMITH'    
        , '011.44.1343.629268'    
        , TO_DATE('23-02-2007', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 7400    
        , .15    
        , 148    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 172    
        , 'Elizabeth'    
        , 'Bates'    
        , 'EBATES'    
        , '011.44.1343.529268'    
        , TO_DATE('24-03-2007', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 7300    
        , .15    
        , 148    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 173    
        , 'Sundita'    
        , 'Kumar'    
        , 'SKUMAR'    
        , '011.44.1343.329268'    
        , TO_DATE('21-04-2008', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 6100    
        , .10    
        , 148    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 174    
        , 'Ellen'    
        , 'Abel'    
        , 'EABEL'    
        , '011.44.1644.429267'    
        , TO_DATE('11-05-2004', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 11000    
        , .30    
        , 149    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 175    
        , 'Alyssa'    
        , 'Hutton'    
        , 'AHUTTON'    
        , '011.44.1644.429266'    
        , TO_DATE('19-03-2005', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 8800    
        , .25    
        , 149    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 176    
        , 'Jonathon'    
        , 'Taylor'    
        , 'JTAYLOR'    
        , '011.44.1644.429265'    
        , TO_DATE('24-03-2006', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 8600    
        , .20    
        , 149    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 177    
        , 'Jack'    
        , 'Livingston'    
        , 'JLIVINGS'    
        , '011.44.1644.429264'    
        , TO_DATE('23-04-2006', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 8400    
        , .20    
        , 149    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 178    
        , 'Kimberely'    
        , 'Grant'    
        , 'KGRANT'    
        , '011.44.1644.429263'    
        , TO_DATE('24-05-2007', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 7000    
        , .15    
        , 149    
        , NULL    
        );    
    
INSERT INTO employees VALUES     
        ( 179    
        , 'Charles'    
        , 'Johnson'    
        , 'CJOHNSON'    
        , '011.44.1644.429262'    
        , TO_DATE('04-01-2008', 'dd-MM-yyyy')    
        , 'SA_REP'    
        , 6200    
        , .10    
        , 149    
        , 80    
        );    
    
INSERT INTO employees VALUES     
        ( 180    
        , 'Winston'    
        , 'Taylor'    
        , 'WTAYLOR'    
        , '650.507.9876'    
        , TO_DATE('24-01-2006', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 3200    
        , NULL    
        , 120    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 181    
        , 'Jean'    
        , 'Fleaur'    
        , 'JFLEAUR'    
        , '650.507.9877'    
        , TO_DATE('23-02-2006', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 3100    
        , NULL    
        , 120    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 182    
        , 'Martha'    
        , 'Sullivan'    
        , 'MSULLIVA'    
        , '650.507.9878'    
        , TO_DATE('21-06-2007', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 2500    
        , NULL    
        , 120    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 183    
        , 'Girard'    
        , 'Geoni'    
        , 'GGEONI'    
        , '650.507.9879'    
        , TO_DATE('03-02-2008', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 2800    
        , NULL    
        , 120    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 184    
        , 'Nandita'    
        , 'Sarchand'    
        , 'NSARCHAN'    
        , '650.509.1876'    
        , TO_DATE('27-01-2004', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 4200    
        , NULL    
        , 121    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 185    
        , 'Alexis'    
        , 'Bull'    
        , 'ABULL'    
        , '650.509.2876'    
        , TO_DATE('20-02-2005', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 4100    
        , NULL    
        , 121    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 186    
        , 'Julia'    
        , 'Dellinger'    
        , 'JDELLING'    
        , '650.509.3876'    
        , TO_DATE('24-06-2006', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 3400    
        , NULL    
        , 121    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 187    
        , 'Anthony'    
        , 'Cabrio'    
        , 'ACABRIO'    
        , '650.509.4876'    
        , TO_DATE('07-02-2007', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 3000    
        , NULL    
        , 121    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 188    
        , 'Kelly'    
        , 'Chung'    
        , 'KCHUNG'    
        , '650.505.1876'    
        , TO_DATE('14-06-2005', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 3800    
        , NULL    
        , 122    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 189    
        , 'Jennifer'    
        , 'Dilly'    
        , 'JDILLY'    
        , '650.505.2876'    
        , TO_DATE('13-08-2005', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 3600    
        , NULL    
        , 122    
        , 50    
        );    
end;

Statement processed.

Statement 25

begin  
INSERT INTO employees VALUES     
        ( 190    
        , 'Timothy'    
        , 'Gates'    
        , 'TGATES'    
        , '650.505.3876'    
        , TO_DATE('11-07-2006', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 2900    
        , NULL    
        , 122    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 191    
        , 'Randall'    
        , 'Perkins'    
        , 'RPERKINS'    
        , '650.505.4876'    
        , TO_DATE('19-12-2007', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 2500    
        , NULL    
        , 122    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 192    
        , 'Sarah'    
        , 'Bell'    
        , 'SBELL'    
        , '650.501.1876'    
        , TO_DATE('04-02-2004', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 4000    
        , NULL    
        , 123    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 193    
        , 'Britney'    
        , 'Everett'    
        , 'BEVERETT'    
        , '650.501.2876'    
        , TO_DATE('03-03-2005', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 3900    
        , NULL    
        , 123    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 194    
        , 'Samuel'    
        , 'McCain'    
        , 'SMCCAIN'    
        , '650.501.3876'    
        , TO_DATE('01-07-2006', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 3200    
        , NULL    
        , 123    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 195    
        , 'Vance'    
        , 'Jones'    
        , 'VJONES'    
        , '650.501.4876'    
        , TO_DATE('17-03-2007', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 2800    
        , NULL    
        , 123    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 196    
        , 'Alana'    
        , 'Walsh'    
        , 'AWALSH'    
        , '650.507.9811'    
        , TO_DATE('24-04-2006', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 3100    
        , NULL    
        , 124    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 197    
        , 'Kevin'    
        , 'Feeney'    
        , 'KFEENEY'    
        , '650.507.9822'    
        , TO_DATE('23-05-2006', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 3000    
        , NULL    
        , 124    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 198    
        , 'Donald'    
        , 'OConnell'    
        , 'DOCONNEL'    
        , '650.507.9833'    
        , TO_DATE('21-06-2007', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 2600    
        , NULL    
        , 124    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 199    
        , 'Douglas'    
        , 'Grant'    
        , 'DGRANT'    
        , '650.507.9844'    
        , TO_DATE('13-01-2008', 'dd-MM-yyyy')    
        , 'SH_CLERK'    
        , 2600    
        , NULL    
        , 124    
        , 50    
        );    
    
INSERT INTO employees VALUES     
        ( 200    
        , 'Jennifer'    
        , 'Whalen'    
        , 'JWHALEN'    
        , '515.123.4444'    
        , TO_DATE('17-09-2003', 'dd-MM-yyyy')    
        , 'AD_ASST'    
        , 4400    
        , NULL    
        , 101    
        , 10    
        );    
    
INSERT INTO employees VALUES     
        ( 201    
        , 'Michael'    
        , 'Hartstein'    
        , 'MHARTSTE'    
        , '515.123.5555'    
        , TO_DATE('17-02-2004', 'dd-MM-yyyy')    
        , 'MK_MAN'    
        , 13000    
        , NULL    
        , 100    
        , 20    
        );    
    
INSERT INTO employees VALUES     
        ( 202    
        , 'Pat'    
        , 'Fay'    
        , 'PFAY'    
        , '603.123.6666'    
        , TO_DATE('17-08-2005', 'dd-MM-yyyy')    
        , 'MK_REP'    
        , 6000    
        , NULL    
        , 201    
        , 20    
        );    
    
INSERT INTO employees VALUES     
        ( 203    
        , 'Susan'    
        , 'Mavris'    
        , 'SMAVRIS'    
        , '515.123.7777'    
        , TO_DATE('07-06-2002', 'dd-MM-yyyy')    
        , 'HR_REP'    
        , 6500    
        , NULL    
        , 101    
        , 40    
        );    
    
INSERT INTO employees VALUES     
        ( 204    
        , 'Hermann'    
        , 'Baer'    
        , 'HBAER'    
        , '515.123.8888'    
        , TO_DATE('07-06-2002', 'dd-MM-yyyy')    
        , 'PR_REP'    
        , 10000    
        , NULL    
        , 101    
        , 70    
        );    
    
INSERT INTO employees VALUES     
        ( 205    
        , 'Shelley'    
        , 'Higgins'    
        , 'SHIGGINS'    
        , '515.123.8080'    
        , TO_DATE('07-06-2002', 'dd-MM-yyyy')    
        , 'AC_MGR'    
        , 12008    
        , NULL    
        , 101    
        , 110    
        );    
    
INSERT INTO employees VALUES     
        ( 206    
        , 'William'    
        , 'Gietz'    
        , 'WGIETZ'    
        , '515.123.8181'    
        , TO_DATE('07-06-2002', 'dd-MM-yyyy')    
        , 'AC_ACCOUNT'    
        , 8300    
        , NULL    
        , 205    
        , 110    
        );    
END;

Statement processed.

Statement 26

BEGIN  
INSERT INTO job_history  
VALUES (102  
       , TO_DATE('13-01-2001', 'dd-MM-yyyy')  
       , TO_DATE('24-07-2006', 'dd-MM-yyyy')  
       , 'IT_PROG'  
       , 60);  
  
INSERT INTO job_history  
VALUES (101  
       , TO_DATE('21-09-1997', 'dd-MM-yyyy')  
       , TO_DATE('27-10-2001', 'dd-MM-yyyy')  
       , 'AC_ACCOUNT'  
       , 110);  
  
INSERT INTO job_history  
VALUES (101  
       , TO_DATE('28-10-2001', 'dd-MM-yyyy')  
       , TO_DATE('15-03-2005', 'dd-MM-yyyy')  
       , 'AC_MGR'  
       , 110);  
  
INSERT INTO job_history  
VALUES (201  
       , TO_DATE('17-02-2004', 'dd-MM-yyyy')  
       , TO_DATE('19-12-2007', 'dd-MM-yyyy')  
       , 'MK_REP'  
       , 20);  
  
INSERT INTO job_history  
VALUES  (114  
        , TO_DATE('24-03-2006', 'dd-MM-yyyy')  
        , TO_DATE('31-12-2007', 'dd-MM-yyyy')  
        , 'ST_CLERK'  
        , 50  
        );  
  
INSERT INTO job_history  
VALUES  (122  
        , TO_DATE('01-01-2007', 'dd-MM-yyyy')  
        , TO_DATE('31-12-2007', 'dd-MM-yyyy')  
        , 'ST_CLERK'  
        , 50  
        );  
  
INSERT INTO job_history  
VALUES  (200  
        , TO_DATE('17-09-1995', 'dd-MM-yyyy')  
        , TO_DATE('17-06-2001', 'dd-MM-yyyy')  
        , 'AD_ASST'  
        , 90  
        );  
  
INSERT INTO job_history  
VALUES  (176  
        , TO_DATE('24-03-2006', 'dd-MM-yyyy')  
        , TO_DATE('31-12-2006', 'dd-MM-yyyy')  
        , 'SA_REP'  
        , 80  
        );  
  
INSERT INTO job_history  
VALUES  (176  
        , TO_DATE('01-01-2007', 'dd-MM-yyyy')  
        , TO_DATE('31-12-2007', 'dd-MM-yyyy')  
        , 'SA_MAN'  
        , 80  
        );  
  
INSERT INTO job_history  
VALUES  (200  
        , TO_DATE('01-07-2002', 'dd-MM-yyyy')  
        , TO_DATE('31-12-2006', 'dd-MM-yyyy')  
        , 'AC_ACCOUNT'  
        , 90  
        );  
END;

Statement processed.

Statement 27

ALTER TABLE departments   
  ENABLE CONSTRAINT dept_mgr_fk

Table altered.

Statement 28

CREATE OR REPLACE PROCEDURE secure_dml  
IS  
BEGIN  
  IF TO_CHAR (SYSDATE, 'HH24:MI') NOT BETWEEN '08:00' AND '18:00'  
        OR TO_CHAR (SYSDATE, 'DY') IN ('SAT', 'SUN') THEN  
	RAISE_APPLICATION_ERROR (-20205,   
		'You may only make changes during normal office hours');  
  END IF;  
END secure_dml;

Procedure created.

Statement 29

CREATE OR REPLACE TRIGGER secure_employees  
  BEFORE INSERT OR UPDATE OR DELETE ON employees  
BEGIN  
  secure_dml;  
END secure_employees;

Trigger created.

Statement 30

ALTER TRIGGER secure_employees DISABLE

Trigger altered.

Statement 31

CREATE OR REPLACE PROCEDURE add_job_history  
  (  p_emp_id          job_history.employee_id%type  
   , p_start_date      job_history.start_date%type  
   , p_end_date        job_history.end_date%type  
   , p_job_id          job_history.job_id%type  
   , p_department_id   job_history.department_id%type   
   )  
IS  
BEGIN  
  INSERT INTO job_history (employee_id, start_date, end_date,   
                           job_id, department_id)  
    VALUES(p_emp_id, p_start_date, p_end_date, p_job_id, p_department_id);  
END add_job_history;

Procedure created.

Statement 32

CREATE OR REPLACE TRIGGER 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;

Trigger created.

Statement 33

COMMENT ON TABLE regions   
IS 'Regions table that contains region numbers and names. Contains 4 rows; references with the Countries table.'

Statement processed.

Statement 34

COMMENT ON COLUMN regions.region_id  
IS 'Primary key of regions table.'

Statement processed.

Statement 35

COMMENT ON COLUMN regions.region_name  
IS 'Names of regions. Locations are in the countries of these regions.'

Statement processed.

Statement 36

COMMENT ON TABLE locations  
IS 'Locations table that contains specific address of a specific office, warehouse, and/or production site of a company. Does not store addresses or locations of customers. Contains 23 rows; references with the departments and countries tables. '

Statement processed.

Statement 37

COMMENT ON COLUMN locations.location_id  
IS 'Primary key of locations table'

Statement processed.

Statement 38

COMMENT ON COLUMN locations.street_address  
IS 'Street address of an office, warehouse, or production site of a company. Contains building number and street name'

Statement processed.

Statement 39

COMMENT ON COLUMN locations.postal_code  
IS 'Postal code of the location of an office, warehouse, or production site of a company. '

Statement processed.

Statement 40

COMMENT ON COLUMN locations.city  
IS 'A not null column that shows city where an office, warehouse, or production site of a company is located. '

Statement processed.

Statement 41

COMMENT ON COLUMN locations.state_province  
IS 'State or Province where an office, warehouse, or production site of a company is located.'

Statement processed.

Statement 42

COMMENT ON COLUMN locations.country_id  
IS 'Country where an office, warehouse, or production site of a company is located. Foreign key to country_id column of the countries table.'

Statement processed.

Statement 43

COMMENT ON TABLE departments  
IS 'Departments table that shows details of departments where employees work. Contains 27 rows; references with locations, employees, and job_history tables.'

Statement processed.

Statement 44

COMMENT ON COLUMN departments.department_id  
IS 'Primary key column of departments table.'

Statement processed.

Statement 45

COMMENT ON COLUMN departments.department_name  
IS 'A not null column that shows name of a department. Administration, Marketing, Purchasing, Human Resources, Shipping, IT, Executive, Public Relations, Sales, Finance, and Accounting. '

Statement processed.

Statement 46

COMMENT ON COLUMN departments.manager_id 
IS 'Manager_id of a department. Foreign key to employee_id column of employees table. The manager_id column of the employee table references this column.'

Statement processed.

Statement 47

COMMENT ON COLUMN departments.location_id  
IS 'Location id where a department is located. Foreign key to location_id column of locations table.'

Statement processed.

Statement 48

COMMENT ON TABLE job_history  
IS 'Table that stores job history of the employees. If an employee  changes departments within the job or changes jobs within the department,  new rows get inserted into this table with old job information of the employee. Contains a complex primary key: employee_id+start_date. Contains 25 rows. References with jobs, employees, and departments tables.'

Statement processed.

Statement 49

COMMENT ON COLUMN job_history.employee_id  
IS 'A not null column in the complex primary key employee_id+start_date. Foreign key to employee_id column of the employee table'

Statement processed.

Statement 50

COMMENT ON COLUMN job_history.start_date  
IS 'A not null column in the complex primary key employee_id+start_date.  Must be less than the end_date of the job_history table. (enforced by constraint jhist_date_interval)'

Statement processed.

Statement 51

COMMENT ON COLUMN job_history.end_date  
IS 'Last day of the employee in this job role. A not null column. Must be greater than the start_date of the job_history table.  (enforced by constraint jhist_date_interval)'

Statement processed.

Statement 52

COMMENT ON COLUMN job_history.job_id  
IS 'Job role in which the employee worked in the past; foreign key to job_id column in the jobs table. A not null column.'

Statement processed.

Statement 53

COMMENT ON COLUMN job_history.department_id 
IS 'Department id in which the employee worked in the past; foreign key to deparment_id column in the departments table'

Statement processed.

Statement 54

COMMENT ON TABLE countries  
IS 'country table. Contains 25 rows. References with locations table.'

Statement processed.

Statement 55

COMMENT ON COLUMN countries.country_id  
IS 'Primary key of countries table.'

Statement processed.

Statement 56

COMMENT ON COLUMN countries.country_name  
IS 'Country name'

Statement processed.

Statement 57

COMMENT ON COLUMN countries.region_id  
IS 'Region ID for the country. Foreign key to region_id column in the departments table.'

Statement processed.

Statement 58

COMMENT ON TABLE jobs  
IS 'jobs table with job titles and salary ranges. Contains 19 rows. References with employees and job_history table.'

Statement processed.

Statement 59

COMMENT ON COLUMN jobs.job_id  
IS 'Primary key of jobs table.'

Statement processed.

Statement 60

COMMENT ON COLUMN jobs.job_title  
IS 'A not null column that shows job title, e.g. AD_VP, FI_ACCOUNTANT'

Statement processed.

Statement 61

COMMENT ON COLUMN jobs.min_salary  
IS 'Minimum salary for a job title.'

Statement processed.

Statement 62

COMMENT ON COLUMN jobs.max_salary  
IS 'Maximum salary for a job title'

Statement processed.

Statement 63

select count(*) from hr_employees

ORA-00942: table or view does not exist

Statement 64

select count(*) from employees

COUNT(*)
107

Statement 65

alter table employees add (last_date_modified timestamp default systimestamp)

Table altered.

Statement 66

alter table employees add (last_date_modified timestamp default systimestamp)

ORA-01430: column being added already exists in table

Statement 67

CREATE OR REPLACE TRIGGER emp_upd_trg 
BEFORE update ON employees 
FOR EACH ROW 
ENABLE 
BEGIN 
    :new.last_date_modified:= systimestamp; 
END;

Trigger created.

Statement 68

update employees set salary = salary * 1.05 where first_name < 'JOHN'

36 row(s) updated.

Statement 69

commit

Statement processed.

Statement 70

select distinct  last_date_modified from employees

LAST_DATE_MODIFIED
19-JUL-22 01.46.17.815887 PM
19-JUL-22 01.46.17.816053 PM
19-JUL-22 01.46.17.816251 PM
19-JUL-22 01.46.17.816269 PM
19-JUL-22 01.46.17.816336 PM
19-JUL-22 01.46.17.766511 PM
19-JUL-22 01.46.17.815903 PM
19-JUL-22 01.46.17.816553 PM
19-JUL-22 01.46.17.816601 PM
19-JUL-22 01.46.17.815829 PM
19-JUL-22 01.46.17.816128 PM
19-JUL-22 01.46.17.816391 PM
19-JUL-22 01.46.17.816199 PM
19-JUL-22 01.46.17.816373 PM
19-JUL-22 01.46.17.816465 PM
19-JUL-22 01.46.17.815936 PM
19-JUL-22 01.46.17.816165 PM
19-JUL-22 01.46.17.816180 PM
19-JUL-22 01.46.17.816236 PM
19-JUL-22 01.46.17.816584 PM
19-JUL-22 01.46.17.816072 PM
19-JUL-22 01.46.17.816427 PM
19-JUL-22 01.46.17.816447 PM
19-JUL-22 01.46.17.816483 PM
19-JUL-22 01.46.17.816091 PM
19-JUL-22 01.46.17.816217 PM
19-JUL-22 01.46.17.816299 PM
19-JUL-22 01.46.17.816355 PM
19-JUL-22 01.46.17.816567 PM
19-JUL-22 01.46.17.815919 PM
19-JUL-22 01.46.17.816013 PM
19-JUL-22 01.46.17.816034 PM
19-JUL-22 01.46.17.816110 PM
19-JUL-22 01.46.17.816147 PM
19-JUL-22 01.46.17.816318 PM
19-JUL-22 01.46.17.816409 PM
19-JUL-22 01.46.17.816537 PM

37 rows selected.

Statement 71

update employees set salary = salary * 0.98 where first_name > 'Paul'

29 row(s) updated.

Statement 72

commit

Statement processed.

Statement 73

select distinct  last_date_modified from employees

LAST_DATE_MODIFIED
19-JUL-22 01.46.17.815887 PM
19-JUL-22 01.46.17.868649 PM
19-JUL-22 01.46.17.816053 PM
19-JUL-22 01.46.17.868851 PM
19-JUL-22 01.46.17.869040 PM
19-JUL-22 01.46.17.816251 PM
19-JUL-22 01.46.17.816269 PM
19-JUL-22 01.46.17.816336 PM
19-JUL-22 01.46.17.869165 PM
19-JUL-22 01.46.17.869274 PM
19-JUL-22 01.46.17.869321 PM
19-JUL-22 01.46.17.766511 PM
19-JUL-22 01.46.17.815903 PM
19-JUL-22 01.46.17.868947 PM
19-JUL-22 01.46.17.869055 PM
19-JUL-22 01.46.17.869110 PM
19-JUL-22 01.46.17.816553 PM
19-JUL-22 01.46.17.816601 PM
19-JUL-22 01.46.17.815829 PM
19-JUL-22 01.46.17.868907 PM
19-JUL-22 01.46.17.816128 PM
19-JUL-22 01.46.17.869022 PM
19-JUL-22 01.46.17.869147 PM
19-JUL-22 01.46.17.816391 PM
19-JUL-22 01.46.17.869183 PM
19-JUL-22 01.46.17.869238 PM
19-JUL-22 01.46.17.868758 PM
19-JUL-22 01.46.17.816199 PM
19-JUL-22 01.46.17.816373 PM
19-JUL-22 01.46.17.816465 PM
19-JUL-22 01.46.17.869305 PM
19-JUL-22 01.46.17.815936 PM
19-JUL-22 01.46.17.868719 PM
19-JUL-22 01.46.17.816165 PM
19-JUL-22 01.46.17.816180 PM
19-JUL-22 01.46.17.816236 PM
19-JUL-22 01.46.17.869092 PM
19-JUL-22 01.46.17.869201 PM
19-JUL-22 01.46.17.869290 PM
19-JUL-22 01.46.17.816584 PM
19-JUL-22 01.46.17.868529 PM
19-JUL-22 01.46.17.816072 PM
19-JUL-22 01.46.17.868793 PM
19-JUL-22 01.46.17.868928 PM
19-JUL-22 01.46.17.816427 PM
19-JUL-22 01.46.17.816447 PM
19-JUL-22 01.46.17.816483 PM
19-JUL-22 01.46.17.816091 PM
19-JUL-22 01.46.17.869003 PM
19-JUL-22 01.46.17.816217 PM

Rows 1 - 50. More rows exist.

Statement 74

select e.first_name, last_date_modified , versions_starttime 
from employeesVERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 1 
                        AND SYSTIMESTAMP

ORA-00933: SQL command not properly ended

Statement 75

select e.first_name, last_date_modified , versions_starttime 
from employeesVERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 1 AND SYSTIMESTAMP

ORA-00933: SQL command not properly ended

Statement 76

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 1 AND SYSTIMESTAMP

ORA-00904: "E"."FIRST_NAME": invalid identifier

Statement 77

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 1 AND SYSTIMESTAMP e

ORA-01466: unable to read data - table definition has changed

Statement 78

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 5/24/60 AND SYSTIMESTAMP e

ORA-01466: unable to read data - table definition has changed

Statement 79

update employees set salary = salary * 0.98 where first_name > 'Paul' 
 
commit

ORA-00933: SQL command not properly ended

Statement 80

update employees set salary = salary * 0.98 where first_name > 'Paul'

29 row(s) updated.

Statement 81

commit

Statement processed.

Statement 82

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e

ORA-01466: unable to read data - table definition has changed

Statement 83

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by first_name

ORA-01466: unable to read data - table definition has changed

Statement 84

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by first_name

ORA-01466: unable to read data - table definition has changed

Statement 85

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by first_name, VERSIONS_STARTTIME

ORA-01466: unable to read data - table definition has changed

Statement 86

update employees set salary = salary * 1.05 where first_name < 'JOHN'

36 row(s) updated.

Statement 87

commit

Statement processed.

Statement 88

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by first_name, VERSIONS_STARTTIME

ORA-01466: unable to read data - table definition has changed

Statement 89

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by first_name, VERSIONS_STARTTIME desc

ORA-01466: unable to read data - table definition has changed

Statement 90

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by first_name, VERSIONS_STARTTIME desc nulls last

ORA-01466: unable to read data - table definition has changed

Statement 91

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by first_name, VERSIONS_STARTTIME desc nulls last

ORA-01466: unable to read data - table definition has changed

Statement 92

update employees set salary = salary * 0.98 where first_name = 'Adam'

1 row(s) updated.

Statement 93

commit

Statement processed.

Statement 94

update employees set salary = salary * 0.98 where first_name = 'Alana'

1 row(s) updated.

Statement 95

commit

Statement processed.

Statement 96

update employees set salary = salary * 0.98 where first_name = 'Alberto'

1 row(s) updated.

Statement 97

commit

Statement processed.

Statement 98

update employees set salary = salary * 0.98 where first_name = 'Alexander'

2 row(s) updated.

Statement 99

commit

Statement processed.

Statement 100

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by first_name, VERSIONS_STARTTIME

ORA-01466: unable to read data - table definition has changed

Statement 101

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > 0.1 
order by first_name, VERSIONS_STARTTIME

ORA-00932: inconsistent datatypes: expected INTERVAL DAY TO SECOND got NUMBER

Statement 102

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:00.1') 
order by first_name, VERSIONS_STARTTIME

ORA-01466: unable to read data - table definition has changed

Statement 103

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:00.5') 
order by first_name, VERSIONS_STARTTIME

ORA-01466: unable to read data - table definition has changed

Statement 104

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:00.8') 
order by first_name, VERSIONS_STARTTIME

ORA-01466: unable to read data - table definition has changed

Statement 105

INSERT INTO employees VALUES (7369,'SMITH','CLERK',7902,to_date('17-12-1980','dd-mm-yyyy'),800,NULL,20)

ORA-00947: not enough values

Statement 106

INSERT INTO employees VALUES (7499,'ALLEN','SALESMAN',7698,to_date('20-2-1981','dd-mm-yyyy'),1600,300,30)

ORA-00947: not enough values

Statement 107

INSERT INTO employees VALUES (7521,'WARD','SALESMAN',7698,to_date('22-2-1981','dd-mm-yyyy'),1250,500,30)

ORA-00947: not enough values

Statement 108

INSERT INTO employees VALUES (7566,'JONES','MANAGER',7839,to_date('2-4-1981','dd-mm-yyyy'),2975,NULL,20)

ORA-00947: not enough values

Statement 109

desc employees

TABLE EMPLOYEES

Column	Null?	Type
EMPLOYEE_ID	NOT NULL	NUMBER(6,0)
FIRST_NAME	-	VARCHAR2(20)
LAST_NAME	NOT NULL	VARCHAR2(25)
EMAIL	NOT NULL	VARCHAR2(25)
PHONE_NUMBER	-	VARCHAR2(20)
HIRE_DATE	NOT NULL	DATE
JOB_ID	NOT NULL	VARCHAR2(10)
SALARY	-	NUMBER(8,2)
COMMISSION_PCT	-	NUMBER(2,2)
MANAGER_ID	-	NUMBER(6,0)
DEPARTMENT_ID	-	NUMBER(4,0)
LAST_DATE_MODIFIED	-	TIMESTAMP(6)

12 rows selected.

Statement 110

select distinct job_id from employees

JOB_ID
AD_VP
FI_ACCOUNT
PU_CLERK
SH_CLERK
HR_REP
AC_MGR
PU_MAN
ST_CLERK
AD_ASST
IT_PROG
SA_MAN
AC_ACCOUNT
FI_MGR
ST_MAN
AD_PRES
MK_MAN
SA_REP
MK_REP
PR_REP

19 rows selected.

Statement 111

desc employees

TABLE EMPLOYEES

Column	Null?	Type
EMPLOYEE_ID	NOT NULL	NUMBER(6,0)
FIRST_NAME	-	VARCHAR2(20)
LAST_NAME	NOT NULL	VARCHAR2(25)
EMAIL	NOT NULL	VARCHAR2(25)
PHONE_NUMBER	-	VARCHAR2(20)
HIRE_DATE	NOT NULL	DATE
JOB_ID	NOT NULL	VARCHAR2(10)
SALARY	-	NUMBER(8,2)
COMMISSION_PCT	-	NUMBER(2,2)
MANAGER_ID	-	NUMBER(6,0)
DEPARTMENT_ID	-	NUMBER(4,0)
LAST_DATE_MODIFIED	-	TIMESTAMP(6)

12 rows selected.

Statement 112

insert into employee (employee_id, first_name, last_name, email, hire_date, job_id) 
values (18192,'Leo', 'Jansen', 'ljansen@dome.dom', 'AD_VP')

ORA-00947: not enough values

Statement 113

insert into employee (employee_id, first_name, last_name, email, hire_date, job_id) 
values (18192,'Leo', 'Jansen', 'ljansen@dome.dom',sysdate, 'AD_VP')

ORA-00942: table or view does not exist

Statement 114

insert into employees (employee_id, first_name, last_name, email, hire_date, job_id) 
values (18192,'Leo', 'Jansen', 'ljansen@dome.dom',sysdate, 'AD_VP')

1 row(s) inserted.

Statement 115

commit

Statement processed.

Statement 116

insert into employees (employee_id, first_name, last_name, email, hire_date, job_id) 
values (18197,'Lars', 'Elstrup', 'lelstrup@dome.dom',sysdate, 'AD_VP')

1 row(s) inserted.

Statement 117

commit

Statement processed.

Statement 118

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 3/24/60 AND SYSTIMESTAMP e      
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Adam	19-JUL-22 01.46.18.099711 PM	-
Alana	19-JUL-22 01.46.18.118739 PM	-
Alberto	19-JUL-22 01.46.18.137758 PM	-
Alexander	19-JUL-22 01.46.18.157314 PM	-
Alexander	19-JUL-22 01.46.18.157346 PM	-
Alexis	19-JUL-22 01.46.18.041466 PM	-
Allan	19-JUL-22 01.46.18.041314 PM	-
Alyssa	19-JUL-22 01.46.18.041437 PM	-
Amit	19-JUL-22 01.46.18.041383 PM	-
Anthony	19-JUL-22 01.46.18.041484 PM	-
Britney	19-JUL-22 01.46.18.041502 PM	-
Bruce	19-JUL-22 01.46.18.040959 PM	-
Charles	19-JUL-22 01.46.18.041639 PM	-
Christopher	19-JUL-22 01.46.18.041296 PM	-
Clara	19-JUL-22 01.46.18.041333 PM	-
Curtis	19-JUL-22 01.46.18.041204 PM	-
Daniel	19-JUL-22 01.46.18.041698 PM	-
Danielle	19-JUL-22 01.46.18.041350 PM	-
David	19-JUL-22 01.46.18.040977 PM	-
David	19-JUL-22 01.46.18.041277 PM	-
David	19-JUL-22 01.46.18.041368 PM	-
Den	19-JUL-22 01.46.18.041023 PM	-
Diana	19-JUL-22 01.46.18.040989 PM	-
Donald	19-JUL-22 01.46.18.041575 PM	-
Douglas	19-JUL-22 01.46.18.041591 PM	-
Eleni	19-JUL-22 01.46.18.041259 PM	-
Elizabeth	19-JUL-22 01.46.18.041622 PM	-
Ellen	19-JUL-22 01.46.18.041419 PM	-
Gerald	19-JUL-22 01.46.18.041241 PM	-
Girard	19-JUL-22 01.46.18.041452 PM	-
Guy	19-JUL-22 01.46.18.041129 PM	-
Harrison	19-JUL-22 01.46.18.041401 PM	-
Hazel	19-JUL-22 01.46.18.041185 PM	-
Hermann	19-JUL-22 01.46.18.041606 PM	-
Irene	19-JUL-22 01.46.18.041166 PM	-
Ismael	19-JUL-22 01.46.18.041006 PM	-
Jack	19-JUL-22 01.46.17.766511 PM	-
James	19-JUL-22 01.46.17.766511 PM	-
James	19-JUL-22 01.46.17.766511 PM	-
Janette	19-JUL-22 01.46.17.766511 PM	-
Jason	19-JUL-22 01.46.17.766511 PM	-
Jean	19-JUL-22 01.46.17.766511 PM	-
Jennifer	19-JUL-22 01.46.17.766511 PM	-
Jennifer	19-JUL-22 01.46.17.766511 PM	-
John	19-JUL-22 01.46.17.766511 PM	-
John	19-JUL-22 01.46.17.766511 PM	-
John	19-JUL-22 01.46.17.766511 PM	-
Jonathon	19-JUL-22 01.46.17.766511 PM	-
Jose Manuel	19-JUL-22 01.46.17.766511 PM	-
Joshua	19-JUL-22 01.46.17.766511 PM	-

Rows 1 - 50. More rows exist.

Statement 119

update employees set salary = salary * 0.98 where first_name = 'Adam'

1 row(s) updated.

Statement 120

commit

Statement processed.

Statement 121

update employees set salary = salary * 1.05 where first_name < 'JOHN'

36 row(s) updated.

Statement 122

commit

Statement processed.

Statement 123

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by first_name, VERSIONS_STARTTIME

ORA-01466: unable to read data - table definition has changed

Statement 124

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 4/24/60 AND SYSTIMESTAMP e      
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Adam	19-JUL-22 01.50.15.095105 PM	19-JUL-22 01.50.12.000000 PM
Adam	19-JUL-22 01.50.27.231816 PM	19-JUL-22 01.50.24.000000 PM
Adam	19-JUL-22 01.46.18.099711 PM	-
Alana	19-JUL-22 01.50.27.232106 PM	19-JUL-22 01.50.24.000000 PM
Alana	19-JUL-22 01.46.18.118739 PM	-
Alberto	19-JUL-22 01.50.27.231865 PM	19-JUL-22 01.50.24.000000 PM
Alberto	19-JUL-22 01.46.18.137758 PM	-
Alexander	19-JUL-22 01.50.27.231625 PM	19-JUL-22 01.50.24.000000 PM
Alexander	19-JUL-22 01.50.27.231784 PM	19-JUL-22 01.50.24.000000 PM
Alexander	19-JUL-22 01.46.18.157314 PM	-
Alexander	19-JUL-22 01.46.18.157346 PM	-
Alexis	19-JUL-22 01.50.27.232070 PM	19-JUL-22 01.50.24.000000 PM
Alexis	19-JUL-22 01.46.18.041466 PM	-
Allan	19-JUL-22 01.50.27.231943 PM	19-JUL-22 01.50.24.000000 PM
Allan	19-JUL-22 01.46.18.041314 PM	-
Alyssa	19-JUL-22 01.50.27.232039 PM	19-JUL-22 01.50.24.000000 PM
Alyssa	19-JUL-22 01.46.18.041437 PM	-
Amit	19-JUL-22 01.50.27.231999 PM	19-JUL-22 01.50.24.000000 PM
Amit	19-JUL-22 01.46.18.041383 PM	-
Anthony	19-JUL-22 01.50.27.232082 PM	19-JUL-22 01.50.24.000000 PM
Anthony	19-JUL-22 01.46.18.041484 PM	-
Britney	19-JUL-22 01.50.27.232095 PM	19-JUL-22 01.50.24.000000 PM
Britney	19-JUL-22 01.46.18.041502 PM	-
Bruce	19-JUL-22 01.50.27.231702 PM	19-JUL-22 01.50.24.000000 PM
Bruce	19-JUL-22 01.46.18.040959 PM	-
Charles	19-JUL-22 01.50.27.232211 PM	19-JUL-22 01.50.24.000000 PM
Charles	19-JUL-22 01.46.18.041639 PM	-
Christopher	19-JUL-22 01.50.27.231930 PM	19-JUL-22 01.50.24.000000 PM
Christopher	19-JUL-22 01.46.18.041296 PM	-
Clara	19-JUL-22 01.50.27.231959 PM	19-JUL-22 01.50.24.000000 PM
Clara	19-JUL-22 01.46.18.041333 PM	-
Curtis	19-JUL-22 01.50.27.231852 PM	19-JUL-22 01.50.24.000000 PM
Curtis	19-JUL-22 01.46.18.041204 PM	-
Daniel	19-JUL-22 01.50.27.232224 PM	19-JUL-22 01.50.24.000000 PM
Daniel	19-JUL-22 01.46.18.041698 PM	-
Danielle	19-JUL-22 01.50.27.231971 PM	19-JUL-22 01.50.24.000000 PM
Danielle	19-JUL-22 01.46.18.041350 PM	-
David	19-JUL-22 01.50.27.231918 PM	19-JUL-22 01.50.24.000000 PM
David	19-JUL-22 01.50.27.231983 PM	19-JUL-22 01.50.24.000000 PM
David	19-JUL-22 01.50.27.231739 PM	19-JUL-22 01.50.24.000000 PM
David	19-JUL-22 01.46.18.040977 PM	-
David	19-JUL-22 01.46.18.041368 PM	-
David	19-JUL-22 01.46.18.041277 PM	-
Den	19-JUL-22 01.50.27.232238 PM	19-JUL-22 01.50.24.000000 PM
Den	19-JUL-22 01.46.18.041023 PM	-
Diana	19-JUL-22 01.50.27.231757 PM	19-JUL-22 01.50.24.000000 PM
Diana	19-JUL-22 01.46.18.040989 PM	-
Donald	19-JUL-22 01.50.27.232141 PM	19-JUL-22 01.50.24.000000 PM
Donald	19-JUL-22 01.46.18.041575 PM	-
Douglas	19-JUL-22 01.50.27.232172 PM	19-JUL-22 01.50.24.000000 PM

Rows 1 - 50. More rows exist.

Statement 125

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 4/24/60 AND SYSTIMESTAMP e      
where first_name like 'L%' 
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Lars	19-JUL-22 01.49.31.561521 PM	19-JUL-22 01.49.30.000000 PM
Laura	19-JUL-22 01.46.17.766511 PM	-
Leo	19-JUL-22 01.48.47.168261 PM	19-JUL-22 01.48.45.000000 PM
Lex	19-JUL-22 01.46.17.766511 PM	-
Lindsey	19-JUL-22 01.46.17.766511 PM	-
Lisa	19-JUL-22 01.46.17.766511 PM	-
Louise	19-JUL-22 01.46.17.766511 PM	-
Luis	19-JUL-22 01.46.17.766511 PM	-

8 rows selected.

Statement 126

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 14/24/60 AND SYSTIMESTAMP e      
where first_name like 'L%' 
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Lars	19-JUL-22 01.49.31.561521 PM	-
Laura	19-JUL-22 01.46.17.766511 PM	-
Leo	19-JUL-22 01.48.47.168261 PM	-
Lex	19-JUL-22 01.46.17.766511 PM	-
Lindsey	19-JUL-22 01.46.17.766511 PM	-
Lisa	19-JUL-22 01.46.17.766511 PM	-
Louise	19-JUL-22 01.46.17.766511 PM	-
Luis	19-JUL-22 01.46.17.766511 PM	-

8 rows selected.

Statement 127

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 14/24/60 AND SYSTIMESTAMP e      
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Adam	19-JUL-22 01.50.27.231816 PM	19-JUL-22 01.50.24.000000 PM
Adam	19-JUL-22 01.50.15.095105 PM	-
Alana	19-JUL-22 01.50.27.232106 PM	19-JUL-22 01.50.24.000000 PM
Alana	19-JUL-22 01.46.18.118739 PM	-
Alberto	19-JUL-22 01.50.27.231865 PM	19-JUL-22 01.50.24.000000 PM
Alberto	19-JUL-22 01.46.18.137758 PM	-
Alexander	19-JUL-22 01.50.27.231625 PM	19-JUL-22 01.50.24.000000 PM
Alexander	19-JUL-22 01.50.27.231784 PM	19-JUL-22 01.50.24.000000 PM
Alexander	19-JUL-22 01.46.18.157346 PM	-
Alexander	19-JUL-22 01.46.18.157314 PM	-
Alexis	19-JUL-22 01.50.27.232070 PM	19-JUL-22 01.50.24.000000 PM
Alexis	19-JUL-22 01.46.18.041466 PM	-
Allan	19-JUL-22 01.50.27.231943 PM	19-JUL-22 01.50.24.000000 PM
Allan	19-JUL-22 01.46.18.041314 PM	-
Alyssa	19-JUL-22 01.50.27.232039 PM	19-JUL-22 01.50.24.000000 PM
Alyssa	19-JUL-22 01.46.18.041437 PM	-
Amit	19-JUL-22 01.50.27.231999 PM	19-JUL-22 01.50.24.000000 PM
Amit	19-JUL-22 01.46.18.041383 PM	-
Anthony	19-JUL-22 01.50.27.232082 PM	19-JUL-22 01.50.24.000000 PM
Anthony	19-JUL-22 01.46.18.041484 PM	-
Britney	19-JUL-22 01.50.27.232095 PM	19-JUL-22 01.50.24.000000 PM
Britney	19-JUL-22 01.46.18.041502 PM	-
Bruce	19-JUL-22 01.50.27.231702 PM	19-JUL-22 01.50.24.000000 PM
Bruce	19-JUL-22 01.46.18.040959 PM	-
Charles	19-JUL-22 01.50.27.232211 PM	19-JUL-22 01.50.24.000000 PM
Charles	19-JUL-22 01.46.18.041639 PM	-
Christopher	19-JUL-22 01.50.27.231930 PM	19-JUL-22 01.50.24.000000 PM
Christopher	19-JUL-22 01.46.18.041296 PM	-
Clara	19-JUL-22 01.50.27.231959 PM	19-JUL-22 01.50.24.000000 PM
Clara	19-JUL-22 01.46.18.041333 PM	-
Curtis	19-JUL-22 01.50.27.231852 PM	19-JUL-22 01.50.24.000000 PM
Curtis	19-JUL-22 01.46.18.041204 PM	-
Daniel	19-JUL-22 01.50.27.232224 PM	19-JUL-22 01.50.24.000000 PM
Daniel	19-JUL-22 01.46.18.041698 PM	-
Danielle	19-JUL-22 01.50.27.231971 PM	19-JUL-22 01.50.24.000000 PM
Danielle	19-JUL-22 01.46.18.041350 PM	-
David	19-JUL-22 01.50.27.231918 PM	19-JUL-22 01.50.24.000000 PM
David	19-JUL-22 01.50.27.231739 PM	19-JUL-22 01.50.24.000000 PM
David	19-JUL-22 01.50.27.231983 PM	19-JUL-22 01.50.24.000000 PM
David	19-JUL-22 01.46.18.041368 PM	-
David	19-JUL-22 01.46.18.040977 PM	-
David	19-JUL-22 01.46.18.041277 PM	-
Den	19-JUL-22 01.50.27.232238 PM	19-JUL-22 01.50.24.000000 PM
Den	19-JUL-22 01.46.18.041023 PM	-
Diana	19-JUL-22 01.50.27.231757 PM	19-JUL-22 01.50.24.000000 PM
Diana	19-JUL-22 01.46.18.040989 PM	-
Donald	19-JUL-22 01.50.27.232141 PM	19-JUL-22 01.50.24.000000 PM
Donald	19-JUL-22 01.46.18.041575 PM	-
Douglas	19-JUL-22 01.50.27.232172 PM	19-JUL-22 01.50.24.000000 PM
Douglas	19-JUL-22 01.46.18.041591 PM	-

Rows 1 - 50. More rows exist.

Statement 128

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 14/24/60 AND SYSTIMESTAMP e      
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Adam	19-JUL-22 01.50.27.231816 PM	-
Alana	19-JUL-22 01.50.27.232106 PM	-
Alberto	19-JUL-22 01.50.27.231865 PM	-
Alexander	19-JUL-22 01.50.27.231625 PM	-
Alexander	19-JUL-22 01.50.27.231784 PM	-
Alexis	19-JUL-22 01.50.27.232070 PM	-
Allan	19-JUL-22 01.50.27.231943 PM	-
Alyssa	19-JUL-22 01.50.27.232039 PM	-
Amit	19-JUL-22 01.50.27.231999 PM	-
Anthony	19-JUL-22 01.50.27.232082 PM	-
Britney	19-JUL-22 01.50.27.232095 PM	-
Bruce	19-JUL-22 01.50.27.231702 PM	-
Charles	19-JUL-22 01.50.27.232211 PM	-
Christopher	19-JUL-22 01.50.27.231930 PM	-
Clara	19-JUL-22 01.50.27.231959 PM	-
Curtis	19-JUL-22 01.50.27.231852 PM	-
Daniel	19-JUL-22 01.50.27.232224 PM	-
Danielle	19-JUL-22 01.50.27.231971 PM	-
David	19-JUL-22 01.50.27.231739 PM	-
David	19-JUL-22 01.50.27.231918 PM	-
David	19-JUL-22 01.50.27.231983 PM	-
Den	19-JUL-22 01.50.27.232238 PM	-
Diana	19-JUL-22 01.50.27.231757 PM	-
Donald	19-JUL-22 01.50.27.232141 PM	-
Douglas	19-JUL-22 01.50.27.232172 PM	-
Eleni	19-JUL-22 01.50.27.231905 PM	-
Elizabeth	19-JUL-22 01.50.27.232197 PM	-
Ellen	19-JUL-22 01.50.27.232026 PM	-
Gerald	19-JUL-22 01.50.27.231893 PM	-
Girard	19-JUL-22 01.50.27.232054 PM	-
Guy	19-JUL-22 01.50.27.231796 PM	-
Harrison	19-JUL-22 01.50.27.232011 PM	-
Hazel	19-JUL-22 01.50.27.231840 PM	-
Hermann	19-JUL-22 01.50.27.232184 PM	-
Irene	19-JUL-22 01.50.27.231828 PM	-
Ismael	19-JUL-22 01.50.27.231770 PM	-
Jack	19-JUL-22 01.46.17.766511 PM	-
James	19-JUL-22 01.46.17.766511 PM	-
James	19-JUL-22 01.46.17.766511 PM	-
Janette	19-JUL-22 01.46.17.766511 PM	-
Jason	19-JUL-22 01.46.17.766511 PM	-
Jean	19-JUL-22 01.46.17.766511 PM	-
Jennifer	19-JUL-22 01.46.17.766511 PM	-
Jennifer	19-JUL-22 01.46.17.766511 PM	-
John	19-JUL-22 01.46.17.766511 PM	-
John	19-JUL-22 01.46.17.766511 PM	-
John	19-JUL-22 01.46.17.766511 PM	-
Jonathon	19-JUL-22 01.46.17.766511 PM	-
Jose Manuel	19-JUL-22 01.46.17.766511 PM	-
Joshua	19-JUL-22 01.46.17.766511 PM	-

Rows 1 - 50. More rows exist.

Statement 129

update employees set salary = salary * 1.05 where first_name < 'JOHN'

36 row(s) updated.

Statement 130

commit

Statement processed.

Statement 131

update employees set salary = salary * 1.05 where first_name = 'ALEXANDER'

0 row(s) updated.

Statement 132

commit

Statement processed.

Statement 133

update employees set salary = salary * 1.05 where first_name like 'ALEX%'

0 row(s) updated.

Statement 134

commit

Statement processed.

Statement 135

update employees set salary = salary * 1.05 where first_name like 'AL%'

0 row(s) updated.

Statement 136

commit

Statement processed.

Statement 137

update employees set salary = salary * 1.05 where first_name like 'A%'

10 row(s) updated.

Statement 138

commit

Statement processed.

Statement 139

update employees set salary = salary * 1.05 where first_name ='LARS'

0 row(s) updated.

Statement 140

commit

Statement processed.

Statement 141

update employees set salary = salary * 1.05 where first_name ='Lars'

1 row(s) updated.

Statement 142

commit

Statement processed.

Statement 143

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:00.8') 
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Adam	19-JUL-22 02.07.54.846409 PM	19-JUL-22 02.07.54.000000 PM
Alana	19-JUL-22 02.07.54.846722 PM	19-JUL-22 02.07.54.000000 PM
Alberto	19-JUL-22 02.07.54.846456 PM	19-JUL-22 02.07.54.000000 PM
Alexander	19-JUL-22 02.07.54.846299 PM	19-JUL-22 02.07.54.000000 PM
Alexander	19-JUL-22 02.07.54.846386 PM	19-JUL-22 02.07.54.000000 PM
Alexis	19-JUL-22 02.07.54.846643 PM	19-JUL-22 02.07.54.000000 PM
Allan	19-JUL-22 02.07.54.846521 PM	19-JUL-22 02.07.54.000000 PM
Alyssa	19-JUL-22 02.07.54.846620 PM	19-JUL-22 02.07.54.000000 PM
Amit	19-JUL-22 02.07.54.846585 PM	19-JUL-22 02.07.54.000000 PM
Anthony	19-JUL-22 02.07.54.846655 PM	19-JUL-22 02.07.54.000000 PM
Britney	19-JUL-22 02.07.54.846668 PM	19-JUL-22 02.07.54.000000 PM
Bruce	19-JUL-22 02.07.54.846334 PM	19-JUL-22 02.07.54.000000 PM
Charles	19-JUL-22 02.07.54.846812 PM	19-JUL-22 02.07.54.000000 PM
Christopher	19-JUL-22 02.07.54.846502 PM	19-JUL-22 02.07.54.000000 PM
Clara	19-JUL-22 02.07.54.846533 PM	19-JUL-22 02.07.54.000000 PM
Curtis	19-JUL-22 02.07.54.846444 PM	19-JUL-22 02.07.54.000000 PM
Daniel	19-JUL-22 02.07.54.846825 PM	19-JUL-22 02.07.54.000000 PM
Danielle	19-JUL-22 02.07.54.846545 PM	19-JUL-22 02.07.54.000000 PM
David	19-JUL-22 02.07.54.846573 PM	19-JUL-22 02.07.54.000000 PM
David	19-JUL-22 02.07.54.846490 PM	19-JUL-22 02.07.54.000000 PM
David	19-JUL-22 02.07.54.846349 PM	19-JUL-22 02.07.54.000000 PM
Den	19-JUL-22 02.07.54.846838 PM	19-JUL-22 02.07.54.000000 PM
Diana	19-JUL-22 02.07.54.846361 PM	19-JUL-22 02.07.54.000000 PM
Donald	19-JUL-22 02.07.54.846761 PM	19-JUL-22 02.07.54.000000 PM
Douglas	19-JUL-22 02.07.54.846774 PM	19-JUL-22 02.07.54.000000 PM
Eleni	19-JUL-22 02.07.54.846479 PM	19-JUL-22 02.07.54.000000 PM
Elizabeth	19-JUL-22 02.07.54.846799 PM	19-JUL-22 02.07.54.000000 PM
Ellen	19-JUL-22 02.07.54.846608 PM	19-JUL-22 02.07.54.000000 PM
Gerald	19-JUL-22 02.07.54.846467 PM	19-JUL-22 02.07.54.000000 PM
Girard	19-JUL-22 02.07.54.846632 PM	19-JUL-22 02.07.54.000000 PM
Guy	19-JUL-22 02.07.54.846397 PM	19-JUL-22 02.07.54.000000 PM
Harrison	19-JUL-22 02.07.54.846596 PM	19-JUL-22 02.07.54.000000 PM
Hazel	19-JUL-22 02.07.54.846432 PM	19-JUL-22 02.07.54.000000 PM
Hermann	19-JUL-22 02.07.54.846786 PM	19-JUL-22 02.07.54.000000 PM
Irene	19-JUL-22 02.07.54.846420 PM	19-JUL-22 02.07.54.000000 PM
Ismael	19-JUL-22 02.07.54.846372 PM	19-JUL-22 02.07.54.000000 PM
Lars	19-JUL-22 02.09.11.797840 PM	19-JUL-22 02.09.09.000000 PM

37 rows selected.

Statement 144

update employees set salary = salary * 0.98 where first_name = 'Adam'

1 row(s) updated.

Statement 145

commit

Statement processed.

Statement 146

update employees set salary = salary * 0.98 where first_name = 'Alana'

1 row(s) updated.

Statement 147

commit

Statement processed.

Statement 148

update employees set salary = salary * 0.98 where first_name > 'Paul'

29 row(s) updated.

Statement 149

commit

Statement processed.

Statement 150

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:00.8') 
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Adam	19-JUL-22 02.07.54.846409 PM	19-JUL-22 02.07.54.000000 PM
Alana	19-JUL-22 02.07.54.846722 PM	19-JUL-22 02.07.54.000000 PM
Alberto	19-JUL-22 02.07.54.846456 PM	19-JUL-22 02.07.54.000000 PM
Alexander	19-JUL-22 02.07.54.846299 PM	19-JUL-22 02.07.54.000000 PM
Alexander	19-JUL-22 02.07.54.846386 PM	19-JUL-22 02.07.54.000000 PM
Alexis	19-JUL-22 02.07.54.846643 PM	19-JUL-22 02.07.54.000000 PM
Allan	19-JUL-22 02.07.54.846521 PM	19-JUL-22 02.07.54.000000 PM
Alyssa	19-JUL-22 02.07.54.846620 PM	19-JUL-22 02.07.54.000000 PM
Amit	19-JUL-22 02.07.54.846585 PM	19-JUL-22 02.07.54.000000 PM
Anthony	19-JUL-22 02.07.54.846655 PM	19-JUL-22 02.07.54.000000 PM
Britney	19-JUL-22 02.07.54.846668 PM	19-JUL-22 02.07.54.000000 PM
Bruce	19-JUL-22 02.07.54.846334 PM	19-JUL-22 02.07.54.000000 PM
Charles	19-JUL-22 02.07.54.846812 PM	19-JUL-22 02.07.54.000000 PM
Christopher	19-JUL-22 02.07.54.846502 PM	19-JUL-22 02.07.54.000000 PM
Clara	19-JUL-22 02.07.54.846533 PM	19-JUL-22 02.07.54.000000 PM
Curtis	19-JUL-22 02.07.54.846444 PM	19-JUL-22 02.07.54.000000 PM
Daniel	19-JUL-22 02.07.54.846825 PM	19-JUL-22 02.07.54.000000 PM
Danielle	19-JUL-22 02.07.54.846545 PM	19-JUL-22 02.07.54.000000 PM
David	19-JUL-22 02.07.54.846573 PM	19-JUL-22 02.07.54.000000 PM
David	19-JUL-22 02.07.54.846490 PM	19-JUL-22 02.07.54.000000 PM
David	19-JUL-22 02.07.54.846349 PM	19-JUL-22 02.07.54.000000 PM
Den	19-JUL-22 02.07.54.846838 PM	19-JUL-22 02.07.54.000000 PM
Diana	19-JUL-22 02.07.54.846361 PM	19-JUL-22 02.07.54.000000 PM
Donald	19-JUL-22 02.07.54.846761 PM	19-JUL-22 02.07.54.000000 PM
Douglas	19-JUL-22 02.07.54.846774 PM	19-JUL-22 02.07.54.000000 PM
Eleni	19-JUL-22 02.07.54.846479 PM	19-JUL-22 02.07.54.000000 PM
Elizabeth	19-JUL-22 02.07.54.846799 PM	19-JUL-22 02.07.54.000000 PM
Ellen	19-JUL-22 02.07.54.846608 PM	19-JUL-22 02.07.54.000000 PM
Gerald	19-JUL-22 02.07.54.846467 PM	19-JUL-22 02.07.54.000000 PM
Girard	19-JUL-22 02.07.54.846632 PM	19-JUL-22 02.07.54.000000 PM
Guy	19-JUL-22 02.07.54.846397 PM	19-JUL-22 02.07.54.000000 PM
Harrison	19-JUL-22 02.07.54.846596 PM	19-JUL-22 02.07.54.000000 PM
Hazel	19-JUL-22 02.07.54.846432 PM	19-JUL-22 02.07.54.000000 PM
Hermann	19-JUL-22 02.07.54.846786 PM	19-JUL-22 02.07.54.000000 PM
Irene	19-JUL-22 02.07.54.846420 PM	19-JUL-22 02.07.54.000000 PM
Ismael	19-JUL-22 02.07.54.846372 PM	19-JUL-22 02.07.54.000000 PM
Lars	19-JUL-22 02.09.11.797840 PM	19-JUL-22 02.09.09.000000 PM
Payam	19-JUL-22 02.11.09.386345 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386479 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386462 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386442 PM	19-JUL-22 02.11.06.000000 PM
Randall	19-JUL-22 02.11.09.386572 PM	19-JUL-22 02.11.06.000000 PM
Randall	19-JUL-22 02.11.09.386430 PM	19-JUL-22 02.11.06.000000 PM
Renske	19-JUL-22 02.11.09.386395 PM	19-JUL-22 02.11.06.000000 PM
Samuel	19-JUL-22 02.11.09.386588 PM	19-JUL-22 02.11.06.000000 PM
Sarah	19-JUL-22 02.11.09.386660 PM	19-JUL-22 02.11.06.000000 PM
Sarath	19-JUL-22 02.11.09.386491 PM	19-JUL-22 02.11.06.000000 PM
Shanta	19-JUL-22 02.11.09.386359 PM	19-JUL-22 02.11.06.000000 PM
Shelley	19-JUL-22 02.11.09.386636 PM	19-JUL-22 02.11.06.000000 PM
Shelli	19-JUL-22 02.11.09.386321 PM	19-JUL-22 02.11.06.000000 PM

Rows 1 - 50. More rows exist.

Statement 151

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:01.1') 
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Lars	19-JUL-22 02.09.11.797840 PM	19-JUL-22 02.09.09.000000 PM
Payam	19-JUL-22 02.11.09.386345 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386442 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386479 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386462 PM	19-JUL-22 02.11.06.000000 PM
Randall	19-JUL-22 02.11.09.386572 PM	19-JUL-22 02.11.06.000000 PM
Randall	19-JUL-22 02.11.09.386430 PM	19-JUL-22 02.11.06.000000 PM
Renske	19-JUL-22 02.11.09.386395 PM	19-JUL-22 02.11.06.000000 PM
Samuel	19-JUL-22 02.11.09.386588 PM	19-JUL-22 02.11.06.000000 PM
Sarah	19-JUL-22 02.11.09.386660 PM	19-JUL-22 02.11.06.000000 PM
Sarath	19-JUL-22 02.11.09.386491 PM	19-JUL-22 02.11.06.000000 PM
Shanta	19-JUL-22 02.11.09.386359 PM	19-JUL-22 02.11.06.000000 PM
Shelley	19-JUL-22 02.11.09.386636 PM	19-JUL-22 02.11.06.000000 PM
Shelli	19-JUL-22 02.11.09.386321 PM	19-JUL-22 02.11.06.000000 PM
Sigal	19-JUL-22 02.11.09.386333 PM	19-JUL-22 02.11.06.000000 PM
Stephen	19-JUL-22 02.11.09.386406 PM	19-JUL-22 02.11.06.000000 PM
Steven	19-JUL-22 02.11.09.386269 PM	19-JUL-22 02.11.06.000000 PM
Steven	19-JUL-22 02.11.09.386371 PM	19-JUL-22 02.11.06.000000 PM
Sundar	19-JUL-22 02.11.09.386502 PM	19-JUL-22 02.11.06.000000 PM
Sundita	19-JUL-22 02.11.09.386537 PM	19-JUL-22 02.11.06.000000 PM
Susan	19-JUL-22 02.11.09.386624 PM	19-JUL-22 02.11.06.000000 PM
TJ	19-JUL-22 02.11.09.386383 PM	19-JUL-22 02.11.06.000000 PM
Tayler	19-JUL-22 02.11.09.386514 PM	19-JUL-22 02.11.06.000000 PM
Timothy	19-JUL-22 02.11.09.386560 PM	19-JUL-22 02.11.06.000000 PM
Trenna	19-JUL-22 02.11.09.386418 PM	19-JUL-22 02.11.06.000000 PM
Valli	19-JUL-22 02.11.09.386306 PM	19-JUL-22 02.11.06.000000 PM
Vance	19-JUL-22 02.11.09.386599 PM	19-JUL-22 02.11.06.000000 PM
William	19-JUL-22 02.11.09.386526 PM	19-JUL-22 02.11.06.000000 PM
William	19-JUL-22 02.11.09.386648 PM	19-JUL-22 02.11.06.000000 PM
Winston	19-JUL-22 02.11.09.386549 PM	19-JUL-22 02.11.06.000000 PM

30 rows selected.

Statement 152

update employees set salary = salary * 0.98 where first_name = 'Lars'

1 row(s) updated.

Statement 153

commit

Statement processed.

Statement 154

update employees set salary = salary * 0.98 where first_name = 'Alana'

1 row(s) updated.

Statement 155

commit

Statement processed.

Statement 156

update employees set salary = salary * 0.98 where first_name = 'Lars'

1 row(s) updated.

Statement 157

commit

Statement processed.

Statement 158

update employees set salary = salary * 0.98 where first_name = 'Adam'

1 row(s) updated.

Statement 159

commit

Statement processed.

Statement 160

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:00.8') 
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Adam	19-JUL-22 02.07.54.846409 PM	19-JUL-22 02.07.54.000000 PM
Adam	19-JUL-22 02.12.23.914448 PM	19-JUL-22 02.12.21.000000 PM
Alana	19-JUL-22 02.07.54.846722 PM	19-JUL-22 02.07.54.000000 PM
Alana	19-JUL-22 02.12.10.576697 PM	19-JUL-22 02.12.09.000000 PM
Alberto	19-JUL-22 02.07.54.846456 PM	19-JUL-22 02.07.54.000000 PM
Alexander	19-JUL-22 02.07.54.846386 PM	19-JUL-22 02.07.54.000000 PM
Alexander	19-JUL-22 02.07.54.846299 PM	19-JUL-22 02.07.54.000000 PM
Alexis	19-JUL-22 02.07.54.846643 PM	19-JUL-22 02.07.54.000000 PM
Allan	19-JUL-22 02.07.54.846521 PM	19-JUL-22 02.07.54.000000 PM
Alyssa	19-JUL-22 02.07.54.846620 PM	19-JUL-22 02.07.54.000000 PM
Amit	19-JUL-22 02.07.54.846585 PM	19-JUL-22 02.07.54.000000 PM
Anthony	19-JUL-22 02.07.54.846655 PM	19-JUL-22 02.07.54.000000 PM
Britney	19-JUL-22 02.07.54.846668 PM	19-JUL-22 02.07.54.000000 PM
Bruce	19-JUL-22 02.07.54.846334 PM	19-JUL-22 02.07.54.000000 PM
Charles	19-JUL-22 02.07.54.846812 PM	19-JUL-22 02.07.54.000000 PM
Christopher	19-JUL-22 02.07.54.846502 PM	19-JUL-22 02.07.54.000000 PM
Clara	19-JUL-22 02.07.54.846533 PM	19-JUL-22 02.07.54.000000 PM
Curtis	19-JUL-22 02.07.54.846444 PM	19-JUL-22 02.07.54.000000 PM
Daniel	19-JUL-22 02.07.54.846825 PM	19-JUL-22 02.07.54.000000 PM
Danielle	19-JUL-22 02.07.54.846545 PM	19-JUL-22 02.07.54.000000 PM
David	19-JUL-22 02.07.54.846349 PM	19-JUL-22 02.07.54.000000 PM
David	19-JUL-22 02.07.54.846573 PM	19-JUL-22 02.07.54.000000 PM
David	19-JUL-22 02.07.54.846490 PM	19-JUL-22 02.07.54.000000 PM
Den	19-JUL-22 02.07.54.846838 PM	19-JUL-22 02.07.54.000000 PM
Diana	19-JUL-22 02.07.54.846361 PM	19-JUL-22 02.07.54.000000 PM
Donald	19-JUL-22 02.07.54.846761 PM	19-JUL-22 02.07.54.000000 PM
Douglas	19-JUL-22 02.07.54.846774 PM	19-JUL-22 02.07.54.000000 PM
Eleni	19-JUL-22 02.07.54.846479 PM	19-JUL-22 02.07.54.000000 PM
Elizabeth	19-JUL-22 02.07.54.846799 PM	19-JUL-22 02.07.54.000000 PM
Ellen	19-JUL-22 02.07.54.846608 PM	19-JUL-22 02.07.54.000000 PM
Gerald	19-JUL-22 02.07.54.846467 PM	19-JUL-22 02.07.54.000000 PM
Girard	19-JUL-22 02.07.54.846632 PM	19-JUL-22 02.07.54.000000 PM
Guy	19-JUL-22 02.07.54.846397 PM	19-JUL-22 02.07.54.000000 PM
Harrison	19-JUL-22 02.07.54.846596 PM	19-JUL-22 02.07.54.000000 PM
Hazel	19-JUL-22 02.07.54.846432 PM	19-JUL-22 02.07.54.000000 PM
Hermann	19-JUL-22 02.07.54.846786 PM	19-JUL-22 02.07.54.000000 PM
Irene	19-JUL-22 02.07.54.846420 PM	19-JUL-22 02.07.54.000000 PM
Ismael	19-JUL-22 02.07.54.846372 PM	19-JUL-22 02.07.54.000000 PM
Lars	19-JUL-22 02.09.11.797840 PM	19-JUL-22 02.09.09.000000 PM
Lars	19-JUL-22 02.12.10.571647 PM	19-JUL-22 02.12.09.000000 PM
Lars	19-JUL-22 02.12.23.908788 PM	19-JUL-22 02.12.21.000000 PM
Payam	19-JUL-22 02.11.09.386345 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386479 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386462 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386442 PM	19-JUL-22 02.11.06.000000 PM
Randall	19-JUL-22 02.11.09.386430 PM	19-JUL-22 02.11.06.000000 PM
Randall	19-JUL-22 02.11.09.386572 PM	19-JUL-22 02.11.06.000000 PM
Renske	19-JUL-22 02.11.09.386395 PM	19-JUL-22 02.11.06.000000 PM
Samuel	19-JUL-22 02.11.09.386588 PM	19-JUL-22 02.11.06.000000 PM
Sarah	19-JUL-22 02.11.09.386660 PM	19-JUL-22 02.11.06.000000 PM

Rows 1 - 50. More rows exist.

Statement 161

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:02.8') 
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Adam	19-JUL-22 02.12.23.914448 PM	19-JUL-22 02.12.21.000000 PM
Lars	19-JUL-22 02.12.23.908788 PM	19-JUL-22 02.12.21.000000 PM
Payam	19-JUL-22 02.11.09.386345 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386462 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386479 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386442 PM	19-JUL-22 02.11.06.000000 PM
Randall	19-JUL-22 02.11.09.386430 PM	19-JUL-22 02.11.06.000000 PM
Randall	19-JUL-22 02.11.09.386572 PM	19-JUL-22 02.11.06.000000 PM
Renske	19-JUL-22 02.11.09.386395 PM	19-JUL-22 02.11.06.000000 PM
Samuel	19-JUL-22 02.11.09.386588 PM	19-JUL-22 02.11.06.000000 PM
Sarah	19-JUL-22 02.11.09.386660 PM	19-JUL-22 02.11.06.000000 PM
Sarath	19-JUL-22 02.11.09.386491 PM	19-JUL-22 02.11.06.000000 PM
Shanta	19-JUL-22 02.11.09.386359 PM	19-JUL-22 02.11.06.000000 PM
Shelley	19-JUL-22 02.11.09.386636 PM	19-JUL-22 02.11.06.000000 PM
Shelli	19-JUL-22 02.11.09.386321 PM	19-JUL-22 02.11.06.000000 PM
Sigal	19-JUL-22 02.11.09.386333 PM	19-JUL-22 02.11.06.000000 PM
Stephen	19-JUL-22 02.11.09.386406 PM	19-JUL-22 02.11.06.000000 PM
Steven	19-JUL-22 02.11.09.386371 PM	19-JUL-22 02.11.06.000000 PM
Steven	19-JUL-22 02.11.09.386269 PM	19-JUL-22 02.11.06.000000 PM
Sundar	19-JUL-22 02.11.09.386502 PM	19-JUL-22 02.11.06.000000 PM
Sundita	19-JUL-22 02.11.09.386537 PM	19-JUL-22 02.11.06.000000 PM
Susan	19-JUL-22 02.11.09.386624 PM	19-JUL-22 02.11.06.000000 PM
TJ	19-JUL-22 02.11.09.386383 PM	19-JUL-22 02.11.06.000000 PM
Tayler	19-JUL-22 02.11.09.386514 PM	19-JUL-22 02.11.06.000000 PM
Timothy	19-JUL-22 02.11.09.386560 PM	19-JUL-22 02.11.06.000000 PM
Trenna	19-JUL-22 02.11.09.386418 PM	19-JUL-22 02.11.06.000000 PM
Valli	19-JUL-22 02.11.09.386306 PM	19-JUL-22 02.11.06.000000 PM
Vance	19-JUL-22 02.11.09.386599 PM	19-JUL-22 02.11.06.000000 PM
William	19-JUL-22 02.11.09.386648 PM	19-JUL-22 02.11.06.000000 PM
William	19-JUL-22 02.11.09.386526 PM	19-JUL-22 02.11.06.000000 PM
Winston	19-JUL-22 02.11.09.386549 PM	19-JUL-22 02.11.06.000000 PM

31 rows selected.

Statement 162

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:04.8') 
order by first_name, VERSIONS_STARTTIME

no data found

Statement 163

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:02.8') 
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Adam	19-JUL-22 02.12.23.914448 PM	19-JUL-22 02.12.21.000000 PM
Lars	19-JUL-22 02.12.23.908788 PM	19-JUL-22 02.12.21.000000 PM
Payam	19-JUL-22 02.11.09.386345 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386462 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386479 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386442 PM	19-JUL-22 02.11.06.000000 PM
Randall	19-JUL-22 02.11.09.386430 PM	19-JUL-22 02.11.06.000000 PM
Randall	19-JUL-22 02.11.09.386572 PM	19-JUL-22 02.11.06.000000 PM
Renske	19-JUL-22 02.11.09.386395 PM	19-JUL-22 02.11.06.000000 PM
Samuel	19-JUL-22 02.11.09.386588 PM	19-JUL-22 02.11.06.000000 PM
Sarah	19-JUL-22 02.11.09.386660 PM	19-JUL-22 02.11.06.000000 PM
Sarath	19-JUL-22 02.11.09.386491 PM	19-JUL-22 02.11.06.000000 PM
Shanta	19-JUL-22 02.11.09.386359 PM	19-JUL-22 02.11.06.000000 PM
Shelley	19-JUL-22 02.11.09.386636 PM	19-JUL-22 02.11.06.000000 PM
Shelli	19-JUL-22 02.11.09.386321 PM	19-JUL-22 02.11.06.000000 PM
Sigal	19-JUL-22 02.11.09.386333 PM	19-JUL-22 02.11.06.000000 PM
Stephen	19-JUL-22 02.11.09.386406 PM	19-JUL-22 02.11.06.000000 PM
Steven	19-JUL-22 02.11.09.386371 PM	19-JUL-22 02.11.06.000000 PM
Steven	19-JUL-22 02.11.09.386269 PM	19-JUL-22 02.11.06.000000 PM
Sundar	19-JUL-22 02.11.09.386502 PM	19-JUL-22 02.11.06.000000 PM
Sundita	19-JUL-22 02.11.09.386537 PM	19-JUL-22 02.11.06.000000 PM
Susan	19-JUL-22 02.11.09.386624 PM	19-JUL-22 02.11.06.000000 PM
TJ	19-JUL-22 02.11.09.386383 PM	19-JUL-22 02.11.06.000000 PM
Tayler	19-JUL-22 02.11.09.386514 PM	19-JUL-22 02.11.06.000000 PM
Timothy	19-JUL-22 02.11.09.386560 PM	19-JUL-22 02.11.06.000000 PM
Trenna	19-JUL-22 02.11.09.386418 PM	19-JUL-22 02.11.06.000000 PM
Valli	19-JUL-22 02.11.09.386306 PM	19-JUL-22 02.11.06.000000 PM
Vance	19-JUL-22 02.11.09.386599 PM	19-JUL-22 02.11.06.000000 PM
William	19-JUL-22 02.11.09.386648 PM	19-JUL-22 02.11.06.000000 PM
William	19-JUL-22 02.11.09.386526 PM	19-JUL-22 02.11.06.000000 PM
Winston	19-JUL-22 02.11.09.386549 PM	19-JUL-22 02.11.06.000000 PM

31 rows selected.

Statement 164

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 15/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:02.8') 
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Adam	19-JUL-22 02.12.23.914448 PM	19-JUL-22 02.12.21.000000 PM
Lars	19-JUL-22 02.12.23.908788 PM	19-JUL-22 02.12.21.000000 PM
Payam	19-JUL-22 02.11.09.386345 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386462 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386479 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386442 PM	19-JUL-22 02.11.06.000000 PM
Randall	19-JUL-22 02.11.09.386430 PM	19-JUL-22 02.11.06.000000 PM
Randall	19-JUL-22 02.11.09.386572 PM	19-JUL-22 02.11.06.000000 PM
Renske	19-JUL-22 02.11.09.386395 PM	19-JUL-22 02.11.06.000000 PM
Samuel	19-JUL-22 02.11.09.386588 PM	19-JUL-22 02.11.06.000000 PM
Sarah	19-JUL-22 02.11.09.386660 PM	19-JUL-22 02.11.06.000000 PM
Sarath	19-JUL-22 02.11.09.386491 PM	19-JUL-22 02.11.06.000000 PM
Shanta	19-JUL-22 02.11.09.386359 PM	19-JUL-22 02.11.06.000000 PM
Shelley	19-JUL-22 02.11.09.386636 PM	19-JUL-22 02.11.06.000000 PM
Shelli	19-JUL-22 02.11.09.386321 PM	19-JUL-22 02.11.06.000000 PM
Sigal	19-JUL-22 02.11.09.386333 PM	19-JUL-22 02.11.06.000000 PM
Stephen	19-JUL-22 02.11.09.386406 PM	19-JUL-22 02.11.06.000000 PM
Steven	19-JUL-22 02.11.09.386371 PM	19-JUL-22 02.11.06.000000 PM
Steven	19-JUL-22 02.11.09.386269 PM	19-JUL-22 02.11.06.000000 PM
Sundar	19-JUL-22 02.11.09.386502 PM	19-JUL-22 02.11.06.000000 PM
Sundita	19-JUL-22 02.11.09.386537 PM	19-JUL-22 02.11.06.000000 PM
Susan	19-JUL-22 02.11.09.386624 PM	19-JUL-22 02.11.06.000000 PM
TJ	19-JUL-22 02.11.09.386383 PM	19-JUL-22 02.11.06.000000 PM
Tayler	19-JUL-22 02.11.09.386514 PM	19-JUL-22 02.11.06.000000 PM
Timothy	19-JUL-22 02.11.09.386560 PM	19-JUL-22 02.11.06.000000 PM
Trenna	19-JUL-22 02.11.09.386418 PM	19-JUL-22 02.11.06.000000 PM
Valli	19-JUL-22 02.11.09.386306 PM	19-JUL-22 02.11.06.000000 PM
Vance	19-JUL-22 02.11.09.386599 PM	19-JUL-22 02.11.06.000000 PM
William	19-JUL-22 02.11.09.386648 PM	19-JUL-22 02.11.06.000000 PM
William	19-JUL-22 02.11.09.386526 PM	19-JUL-22 02.11.06.000000 PM
Winston	19-JUL-22 02.11.09.386549 PM	19-JUL-22 02.11.06.000000 PM

31 rows selected.

Statement 165

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 20/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:02.8') 
order by first_name, VERSIONS_STARTTIME

ORA-30052: invalid lower limit snapshot expression

Statement 166

show parameter undo_retention

no data found

Statement 167

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 20/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:02.8') 
order by first_name, VERSIONS_STARTTIME

ORA-30052: invalid lower limit snapshot expression

Statement 168

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 16/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:02.8') 
order by first_name, VERSIONS_STARTTIME 
 
show parameter undo_retention

ORA-00933: SQL command not properly ended

Statement 169

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 16/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:02.8') 
order by first_name, VERSIONS_STARTTIME

ORA-30052: invalid lower limit snapshot expression

Statement 170

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 15/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:02.8') 
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Adam	19-JUL-22 02.12.23.914448 PM	19-JUL-22 02.12.21.000000 PM
Lars	19-JUL-22 02.12.23.908788 PM	19-JUL-22 02.12.21.000000 PM
Payam	19-JUL-22 02.11.09.386345 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386462 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386479 PM	19-JUL-22 02.11.06.000000 PM
Peter	19-JUL-22 02.11.09.386442 PM	19-JUL-22 02.11.06.000000 PM
Randall	19-JUL-22 02.11.09.386430 PM	19-JUL-22 02.11.06.000000 PM
Randall	19-JUL-22 02.11.09.386572 PM	19-JUL-22 02.11.06.000000 PM
Renske	19-JUL-22 02.11.09.386395 PM	19-JUL-22 02.11.06.000000 PM
Samuel	19-JUL-22 02.11.09.386588 PM	19-JUL-22 02.11.06.000000 PM
Sarah	19-JUL-22 02.11.09.386660 PM	19-JUL-22 02.11.06.000000 PM
Sarath	19-JUL-22 02.11.09.386491 PM	19-JUL-22 02.11.06.000000 PM
Shanta	19-JUL-22 02.11.09.386359 PM	19-JUL-22 02.11.06.000000 PM
Shelley	19-JUL-22 02.11.09.386636 PM	19-JUL-22 02.11.06.000000 PM
Shelli	19-JUL-22 02.11.09.386321 PM	19-JUL-22 02.11.06.000000 PM
Sigal	19-JUL-22 02.11.09.386333 PM	19-JUL-22 02.11.06.000000 PM
Stephen	19-JUL-22 02.11.09.386406 PM	19-JUL-22 02.11.06.000000 PM
Steven	19-JUL-22 02.11.09.386371 PM	19-JUL-22 02.11.06.000000 PM
Steven	19-JUL-22 02.11.09.386269 PM	19-JUL-22 02.11.06.000000 PM
Sundar	19-JUL-22 02.11.09.386502 PM	19-JUL-22 02.11.06.000000 PM
Sundita	19-JUL-22 02.11.09.386537 PM	19-JUL-22 02.11.06.000000 PM
Susan	19-JUL-22 02.11.09.386624 PM	19-JUL-22 02.11.06.000000 PM
TJ	19-JUL-22 02.11.09.386383 PM	19-JUL-22 02.11.06.000000 PM
Tayler	19-JUL-22 02.11.09.386514 PM	19-JUL-22 02.11.06.000000 PM
Timothy	19-JUL-22 02.11.09.386560 PM	19-JUL-22 02.11.06.000000 PM
Trenna	19-JUL-22 02.11.09.386418 PM	19-JUL-22 02.11.06.000000 PM
Valli	19-JUL-22 02.11.09.386306 PM	19-JUL-22 02.11.06.000000 PM
Vance	19-JUL-22 02.11.09.386599 PM	19-JUL-22 02.11.06.000000 PM
William	19-JUL-22 02.11.09.386648 PM	19-JUL-22 02.11.06.000000 PM
William	19-JUL-22 02.11.09.386526 PM	19-JUL-22 02.11.06.000000 PM
Winston	19-JUL-22 02.11.09.386549 PM	19-JUL-22 02.11.06.000000 PM

31 rows selected.

Statement 171

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 15/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:02.8') 
order by first_name, VERSIONS_STARTTIME

no data found

Statement 172

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 15/24/60 AND SYSTIMESTAMP e      
-- where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:02.8') 
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Adam	19-JUL-22 02.12.23.914448 PM	-
Alana	19-JUL-22 02.12.10.576697 PM	-
Alberto	19-JUL-22 02.08.42.704776 PM	-
Alexander	19-JUL-22 02.08.42.704652 PM	-
Alexander	19-JUL-22 02.08.42.704734 PM	-
Alexis	19-JUL-22 02.08.42.704826 PM	-
Allan	19-JUL-22 02.08.42.704788 PM	-
Alyssa	19-JUL-22 02.08.42.704814 PM	-
Amit	19-JUL-22 02.08.42.704802 PM	-
Anthony	19-JUL-22 02.08.42.704838 PM	-
Britney	19-JUL-22 02.07.54.846668 PM	-
Bruce	19-JUL-22 02.07.54.846334 PM	-
Charles	19-JUL-22 02.07.54.846812 PM	-
Christopher	19-JUL-22 02.07.54.846502 PM	-
Clara	19-JUL-22 02.07.54.846533 PM	-
Curtis	19-JUL-22 02.07.54.846444 PM	-
Daniel	19-JUL-22 02.07.54.846825 PM	-
Danielle	19-JUL-22 02.07.54.846545 PM	-
David	19-JUL-22 02.07.54.846349 PM	-
David	19-JUL-22 02.07.54.846490 PM	-
David	19-JUL-22 02.07.54.846573 PM	-
Den	19-JUL-22 02.07.54.846838 PM	-
Diana	19-JUL-22 02.07.54.846361 PM	-
Donald	19-JUL-22 02.07.54.846761 PM	-
Douglas	19-JUL-22 02.07.54.846774 PM	-
Eleni	19-JUL-22 02.07.54.846479 PM	-
Elizabeth	19-JUL-22 02.07.54.846799 PM	-
Ellen	19-JUL-22 02.07.54.846608 PM	-
Gerald	19-JUL-22 02.07.54.846467 PM	-
Girard	19-JUL-22 02.07.54.846632 PM	-
Guy	19-JUL-22 02.07.54.846397 PM	-
Harrison	19-JUL-22 02.07.54.846596 PM	-
Hazel	19-JUL-22 02.07.54.846432 PM	-
Hermann	19-JUL-22 02.07.54.846786 PM	-
Irene	19-JUL-22 02.07.54.846420 PM	-
Ismael	19-JUL-22 02.07.54.846372 PM	-
Jack	19-JUL-22 01.46.17.766511 PM	-
James	19-JUL-22 01.46.17.766511 PM	-
James	19-JUL-22 01.46.17.766511 PM	-
Janette	19-JUL-22 01.46.17.766511 PM	-
Jason	19-JUL-22 01.46.17.766511 PM	-
Jean	19-JUL-22 01.46.17.766511 PM	-
Jennifer	19-JUL-22 01.46.17.766511 PM	-
Jennifer	19-JUL-22 01.46.17.766511 PM	-
John	19-JUL-22 01.46.17.766511 PM	-
John	19-JUL-22 01.46.17.766511 PM	-
John	19-JUL-22 01.46.17.766511 PM	-
Jonathon	19-JUL-22 01.46.17.766511 PM	-
Jose Manuel	19-JUL-22 01.46.17.766511 PM	-
Joshua	19-JUL-22 01.46.17.766511 PM	-

Rows 1 - 50. More rows exist.

Statement 173

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 15/24/60 AND SYSTIMESTAMP e      
-- where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:02.8') 
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Adam	19-JUL-22 02.12.23.914448 PM	-
Alana	19-JUL-22 02.12.10.576697 PM	-
Alberto	19-JUL-22 02.08.42.704776 PM	-
Alexander	19-JUL-22 02.08.42.704652 PM	-
Alexander	19-JUL-22 02.08.42.704734 PM	-
Alexis	19-JUL-22 02.08.42.704826 PM	-
Allan	19-JUL-22 02.08.42.704788 PM	-
Alyssa	19-JUL-22 02.08.42.704814 PM	-
Amit	19-JUL-22 02.08.42.704802 PM	-
Anthony	19-JUL-22 02.08.42.704838 PM	-
Britney	19-JUL-22 02.07.54.846668 PM	-
Bruce	19-JUL-22 02.07.54.846334 PM	-
Charles	19-JUL-22 02.07.54.846812 PM	-
Christopher	19-JUL-22 02.07.54.846502 PM	-
Clara	19-JUL-22 02.07.54.846533 PM	-
Curtis	19-JUL-22 02.07.54.846444 PM	-
Daniel	19-JUL-22 02.07.54.846825 PM	-
Danielle	19-JUL-22 02.07.54.846545 PM	-
David	19-JUL-22 02.07.54.846349 PM	-
David	19-JUL-22 02.07.54.846490 PM	-
David	19-JUL-22 02.07.54.846573 PM	-
Den	19-JUL-22 02.07.54.846838 PM	-
Diana	19-JUL-22 02.07.54.846361 PM	-
Donald	19-JUL-22 02.07.54.846761 PM	-
Douglas	19-JUL-22 02.07.54.846774 PM	-
Eleni	19-JUL-22 02.07.54.846479 PM	-
Elizabeth	19-JUL-22 02.07.54.846799 PM	-
Ellen	19-JUL-22 02.07.54.846608 PM	-
Gerald	19-JUL-22 02.07.54.846467 PM	-
Girard	19-JUL-22 02.07.54.846632 PM	-
Guy	19-JUL-22 02.07.54.846397 PM	-
Harrison	19-JUL-22 02.07.54.846596 PM	-
Hazel	19-JUL-22 02.07.54.846432 PM	-
Hermann	19-JUL-22 02.07.54.846786 PM	-
Irene	19-JUL-22 02.07.54.846420 PM	-
Ismael	19-JUL-22 02.07.54.846372 PM	-
Jack	19-JUL-22 01.46.17.766511 PM	-
James	19-JUL-22 01.46.17.766511 PM	-
James	19-JUL-22 01.46.17.766511 PM	-
Janette	19-JUL-22 01.46.17.766511 PM	-
Jason	19-JUL-22 01.46.17.766511 PM	-
Jean	19-JUL-22 01.46.17.766511 PM	-
Jennifer	19-JUL-22 01.46.17.766511 PM	-
Jennifer	19-JUL-22 01.46.17.766511 PM	-
John	19-JUL-22 01.46.17.766511 PM	-
John	19-JUL-22 01.46.17.766511 PM	-
John	19-JUL-22 01.46.17.766511 PM	-
Jonathon	19-JUL-22 01.46.17.766511 PM	-
Jose Manuel	19-JUL-22 01.46.17.766511 PM	-
Joshua	19-JUL-22 01.46.17.766511 PM	-

Rows 1 - 50. More rows exist.

Statement 174

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 15/24/60 AND SYSTIMESTAMP e      
-- where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:02.8') 
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Adam	19-JUL-22 02.12.23.914448 PM	-
Alana	19-JUL-22 02.12.10.576697 PM	-
Alberto	19-JUL-22 02.08.42.704776 PM	-
Alexander	19-JUL-22 02.08.42.704652 PM	-
Alexander	19-JUL-22 02.08.42.704734 PM	-
Alexis	19-JUL-22 02.08.42.704826 PM	-
Allan	19-JUL-22 02.08.42.704788 PM	-
Alyssa	19-JUL-22 02.08.42.704814 PM	-
Amit	19-JUL-22 02.08.42.704802 PM	-
Anthony	19-JUL-22 02.08.42.704838 PM	-
Britney	19-JUL-22 02.07.54.846668 PM	-
Bruce	19-JUL-22 02.07.54.846334 PM	-
Charles	19-JUL-22 02.07.54.846812 PM	-
Christopher	19-JUL-22 02.07.54.846502 PM	-
Clara	19-JUL-22 02.07.54.846533 PM	-
Curtis	19-JUL-22 02.07.54.846444 PM	-
Daniel	19-JUL-22 02.07.54.846825 PM	-
Danielle	19-JUL-22 02.07.54.846545 PM	-
David	19-JUL-22 02.07.54.846349 PM	-
David	19-JUL-22 02.07.54.846490 PM	-
David	19-JUL-22 02.07.54.846573 PM	-
Den	19-JUL-22 02.07.54.846838 PM	-
Diana	19-JUL-22 02.07.54.846361 PM	-
Donald	19-JUL-22 02.07.54.846761 PM	-
Douglas	19-JUL-22 02.07.54.846774 PM	-
Eleni	19-JUL-22 02.07.54.846479 PM	-
Elizabeth	19-JUL-22 02.07.54.846799 PM	-
Ellen	19-JUL-22 02.07.54.846608 PM	-
Gerald	19-JUL-22 02.07.54.846467 PM	-
Girard	19-JUL-22 02.07.54.846632 PM	-
Guy	19-JUL-22 02.07.54.846397 PM	-
Harrison	19-JUL-22 02.07.54.846596 PM	-
Hazel	19-JUL-22 02.07.54.846432 PM	-
Hermann	19-JUL-22 02.07.54.846786 PM	-
Irene	19-JUL-22 02.07.54.846420 PM	-
Ismael	19-JUL-22 02.07.54.846372 PM	-
Jack	19-JUL-22 01.46.17.766511 PM	-
James	19-JUL-22 01.46.17.766511 PM	-
James	19-JUL-22 01.46.17.766511 PM	-
Janette	19-JUL-22 01.46.17.766511 PM	-
Jason	19-JUL-22 01.46.17.766511 PM	-
Jean	19-JUL-22 01.46.17.766511 PM	-
Jennifer	19-JUL-22 01.46.17.766511 PM	-
Jennifer	19-JUL-22 01.46.17.766511 PM	-
John	19-JUL-22 01.46.17.766511 PM	-
John	19-JUL-22 01.46.17.766511 PM	-
John	19-JUL-22 01.46.17.766511 PM	-
Jonathon	19-JUL-22 01.46.17.766511 PM	-
Jose Manuel	19-JUL-22 01.46.17.766511 PM	-
Joshua	19-JUL-22 01.46.17.766511 PM	-

Rows 1 - 50. More rows exist.

Statement 175

update employees set salary = salary * 0.98 where first_name = 'Adam'

1 row(s) updated.

Statement 176

commit

Statement processed.

Statement 177

update employees set salary = salary * 0.98 where first_name = 'Alana'

1 row(s) updated.

Statement 178

commit

Statement processed.

Statement 179

update employees set salary = salary * 0.98 where first_name > 'Paul'

29 row(s) updated.

Statement 180

commit

Statement processed.

Statement 181

select e.first_name, last_date_modified , versions_starttime 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
where last_date_modified - versions_starttime > TO_DSINTERVAL('0 00:00:00.8') 
order by first_name, VERSIONS_STARTTIME

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME
Adam	19-JUL-22 02.39.20.124079 PM	19-JUL-22 02.39.19.000000 PM
Alana	19-JUL-22 02.39.20.128852 PM	19-JUL-22 02.39.19.000000 PM
Payam	19-JUL-22 02.39.36.835396 PM	19-JUL-22 02.39.34.000000 PM
Peter	19-JUL-22 02.39.36.835515 PM	19-JUL-22 02.39.34.000000 PM
Peter	19-JUL-22 02.39.36.835492 PM	19-JUL-22 02.39.34.000000 PM
Peter	19-JUL-22 02.39.36.835503 PM	19-JUL-22 02.39.34.000000 PM
Randall	19-JUL-22 02.39.36.835608 PM	19-JUL-22 02.39.34.000000 PM
Randall	19-JUL-22 02.39.36.835480 PM	19-JUL-22 02.39.34.000000 PM
Renske	19-JUL-22 02.39.36.835446 PM	19-JUL-22 02.39.34.000000 PM
Samuel	19-JUL-22 02.39.36.835620 PM	19-JUL-22 02.39.34.000000 PM
Sarah	19-JUL-22 02.39.36.835721 PM	19-JUL-22 02.39.34.000000 PM
Sarath	19-JUL-22 02.39.36.835527 PM	19-JUL-22 02.39.34.000000 PM
Shanta	19-JUL-22 02.39.36.835410 PM	19-JUL-22 02.39.34.000000 PM
Shelley	19-JUL-22 02.39.36.835695 PM	19-JUL-22 02.39.34.000000 PM
Shelli	19-JUL-22 02.39.36.835372 PM	19-JUL-22 02.39.34.000000 PM
Sigal	19-JUL-22 02.39.36.835384 PM	19-JUL-22 02.39.34.000000 PM
Stephen	19-JUL-22 02.39.36.835457 PM	19-JUL-22 02.39.34.000000 PM
Steven	19-JUL-22 02.39.36.835422 PM	19-JUL-22 02.39.34.000000 PM
Steven	19-JUL-22 02.39.36.835324 PM	19-JUL-22 02.39.34.000000 PM
Sundar	19-JUL-22 02.39.36.835538 PM	19-JUL-22 02.39.34.000000 PM
Sundita	19-JUL-22 02.39.36.835573 PM	19-JUL-22 02.39.34.000000 PM
Susan	19-JUL-22 02.39.36.835660 PM	19-JUL-22 02.39.34.000000 PM
TJ	19-JUL-22 02.39.36.835434 PM	19-JUL-22 02.39.34.000000 PM
Tayler	19-JUL-22 02.39.36.835550 PM	19-JUL-22 02.39.34.000000 PM
Timothy	19-JUL-22 02.39.36.835596 PM	19-JUL-22 02.39.34.000000 PM
Trenna	19-JUL-22 02.39.36.835469 PM	19-JUL-22 02.39.34.000000 PM
Valli	19-JUL-22 02.39.36.835358 PM	19-JUL-22 02.39.34.000000 PM
Vance	19-JUL-22 02.39.36.835631 PM	19-JUL-22 02.39.34.000000 PM
William	19-JUL-22 02.39.36.835561 PM	19-JUL-22 02.39.34.000000 PM
William	19-JUL-22 02.39.36.835709 PM	19-JUL-22 02.39.34.000000 PM
Winston	19-JUL-22 02.39.36.835585 PM	19-JUL-22 02.39.34.000000 PM

31 rows selected.

Statement 182

select * 
from ( select e.first_name 
       ,      e.last_date_modified  
       ,      e.versions_starttime 
       ,      row_number() over (partition by e.employee_id order by e.versions_starttime) rn 
       from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
) 
where rn = 1

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME	RN
Steven	19-JUL-22 02.39.36.835324 PM	19-JUL-22 02.39.34.000000 PM	1
Neena	19-JUL-22 01.46.17.766511 PM	-	1
Lex	19-JUL-22 01.46.17.766511 PM	-	1
Alexander	19-JUL-22 02.08.42.704652 PM	-	1
Bruce	19-JUL-22 02.07.54.846334 PM	-	1
David	19-JUL-22 02.07.54.846349 PM	-	1
Valli	19-JUL-22 02.39.36.835358 PM	19-JUL-22 02.39.34.000000 PM	1
Diana	19-JUL-22 02.07.54.846361 PM	-	1
Nancy	19-JUL-22 01.46.17.766511 PM	-	1
Daniel	19-JUL-22 02.07.54.846825 PM	-	1
John	19-JUL-22 01.46.17.766511 PM	-	1
Ismael	19-JUL-22 02.07.54.846372 PM	-	1
Jose Manuel	19-JUL-22 01.46.17.766511 PM	-	1
Luis	19-JUL-22 01.46.17.766511 PM	-	1
Den	19-JUL-22 02.07.54.846838 PM	-	1
Alexander	19-JUL-22 02.08.42.704734 PM	-	1
Shelli	19-JUL-22 02.39.36.835372 PM	19-JUL-22 02.39.34.000000 PM	1
Sigal	19-JUL-22 02.39.36.835384 PM	19-JUL-22 02.39.34.000000 PM	1
Guy	19-JUL-22 02.07.54.846397 PM	-	1
Karen	19-JUL-22 01.46.17.766511 PM	-	1
Matthew	19-JUL-22 01.46.17.766511 PM	-	1
Adam	19-JUL-22 02.39.20.124079 PM	19-JUL-22 02.39.19.000000 PM	1
Payam	19-JUL-22 02.39.36.835396 PM	19-JUL-22 02.39.34.000000 PM	1
Shanta	19-JUL-22 02.39.36.835410 PM	19-JUL-22 02.39.34.000000 PM	1
Kevin	19-JUL-22 01.46.17.766511 PM	-	1
Julia	19-JUL-22 01.46.17.766511 PM	-	1
Irene	19-JUL-22 02.07.54.846420 PM	-	1
James	19-JUL-22 01.46.17.766511 PM	-	1
Steven	19-JUL-22 02.39.36.835422 PM	19-JUL-22 02.39.34.000000 PM	1
Laura	19-JUL-22 01.46.17.766511 PM	-	1
Mozhe	19-JUL-22 01.46.17.766511 PM	-	1
James	19-JUL-22 01.46.17.766511 PM	-	1
TJ	19-JUL-22 02.39.36.835434 PM	19-JUL-22 02.39.34.000000 PM	1
Jason	19-JUL-22 01.46.17.766511 PM	-	1
Michael	19-JUL-22 01.46.17.766511 PM	-	1
Ki	19-JUL-22 01.46.17.766511 PM	-	1
Hazel	19-JUL-22 02.07.54.846432 PM	-	1
Renske	19-JUL-22 02.39.36.835446 PM	19-JUL-22 02.39.34.000000 PM	1
Stephen	19-JUL-22 02.39.36.835457 PM	19-JUL-22 02.39.34.000000 PM	1
John	19-JUL-22 01.46.17.766511 PM	-	1
Joshua	19-JUL-22 01.46.17.766511 PM	-	1
Trenna	19-JUL-22 02.39.36.835469 PM	19-JUL-22 02.39.34.000000 PM	1
Curtis	19-JUL-22 02.07.54.846444 PM	-	1
Randall	19-JUL-22 02.39.36.835480 PM	19-JUL-22 02.39.34.000000 PM	1
Peter	19-JUL-22 02.39.36.835492 PM	19-JUL-22 02.39.34.000000 PM	1
John	19-JUL-22 01.46.17.766511 PM	-	1
Karen	19-JUL-22 01.46.17.766511 PM	-	1
Alberto	19-JUL-22 02.08.42.704776 PM	-	1
Gerald	19-JUL-22 02.07.54.846467 PM	-	1
Eleni	19-JUL-22 02.07.54.846479 PM	-	1

Rows 1 - 50. More rows exist.

Statement 183

select * 
from ( select e.first_name 
       ,      e.last_date_modified  
       ,      e.versions_starttime 
       ,      row_number() over (partition by e.employee_id order by e.versions_starttime) rn 
       from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
) 
where rn = 1

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME	RN
Steven	19-JUL-22 02.39.36.835324 PM	19-JUL-22 02.39.34.000000 PM	1
Neena	19-JUL-22 01.46.17.766511 PM	-	1
Lex	19-JUL-22 01.46.17.766511 PM	-	1
Alexander	19-JUL-22 02.08.42.704652 PM	-	1
Bruce	19-JUL-22 02.07.54.846334 PM	-	1
David	19-JUL-22 02.07.54.846349 PM	-	1
Valli	19-JUL-22 02.39.36.835358 PM	19-JUL-22 02.39.34.000000 PM	1
Diana	19-JUL-22 02.07.54.846361 PM	-	1
Nancy	19-JUL-22 01.46.17.766511 PM	-	1
Daniel	19-JUL-22 02.07.54.846825 PM	-	1
John	19-JUL-22 01.46.17.766511 PM	-	1
Ismael	19-JUL-22 02.07.54.846372 PM	-	1
Jose Manuel	19-JUL-22 01.46.17.766511 PM	-	1
Luis	19-JUL-22 01.46.17.766511 PM	-	1
Den	19-JUL-22 02.07.54.846838 PM	-	1
Alexander	19-JUL-22 02.08.42.704734 PM	-	1
Shelli	19-JUL-22 02.39.36.835372 PM	19-JUL-22 02.39.34.000000 PM	1
Sigal	19-JUL-22 02.39.36.835384 PM	19-JUL-22 02.39.34.000000 PM	1
Guy	19-JUL-22 02.07.54.846397 PM	-	1
Karen	19-JUL-22 01.46.17.766511 PM	-	1
Matthew	19-JUL-22 01.46.17.766511 PM	-	1
Adam	19-JUL-22 02.39.20.124079 PM	19-JUL-22 02.39.19.000000 PM	1
Payam	19-JUL-22 02.39.36.835396 PM	19-JUL-22 02.39.34.000000 PM	1
Shanta	19-JUL-22 02.39.36.835410 PM	19-JUL-22 02.39.34.000000 PM	1
Kevin	19-JUL-22 01.46.17.766511 PM	-	1
Julia	19-JUL-22 01.46.17.766511 PM	-	1
Irene	19-JUL-22 02.07.54.846420 PM	-	1
James	19-JUL-22 01.46.17.766511 PM	-	1
Steven	19-JUL-22 02.39.36.835422 PM	19-JUL-22 02.39.34.000000 PM	1
Laura	19-JUL-22 01.46.17.766511 PM	-	1
Mozhe	19-JUL-22 01.46.17.766511 PM	-	1
James	19-JUL-22 01.46.17.766511 PM	-	1
TJ	19-JUL-22 02.39.36.835434 PM	19-JUL-22 02.39.34.000000 PM	1
Jason	19-JUL-22 01.46.17.766511 PM	-	1
Michael	19-JUL-22 01.46.17.766511 PM	-	1
Ki	19-JUL-22 01.46.17.766511 PM	-	1
Hazel	19-JUL-22 02.07.54.846432 PM	-	1
Renske	19-JUL-22 02.39.36.835446 PM	19-JUL-22 02.39.34.000000 PM	1
Stephen	19-JUL-22 02.39.36.835457 PM	19-JUL-22 02.39.34.000000 PM	1
John	19-JUL-22 01.46.17.766511 PM	-	1
Joshua	19-JUL-22 01.46.17.766511 PM	-	1
Trenna	19-JUL-22 02.39.36.835469 PM	19-JUL-22 02.39.34.000000 PM	1
Curtis	19-JUL-22 02.07.54.846444 PM	-	1
Randall	19-JUL-22 02.39.36.835480 PM	19-JUL-22 02.39.34.000000 PM	1
Peter	19-JUL-22 02.39.36.835492 PM	19-JUL-22 02.39.34.000000 PM	1
John	19-JUL-22 01.46.17.766511 PM	-	1
Karen	19-JUL-22 01.46.17.766511 PM	-	1
Alberto	19-JUL-22 02.08.42.704776 PM	-	1
Gerald	19-JUL-22 02.07.54.846467 PM	-	1
Eleni	19-JUL-22 02.07.54.846479 PM	-	1

Rows 1 - 50. More rows exist.

Statement 184

select * 
from ( select e.first_name 
       ,      e.last_date_modified  
       ,      e.versions_starttime 
       ,      row_number() over (partition by e.employee_id order by e.versions_starttime) rn 
       from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
) 
where rn = 1

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME	RN
Steven	19-JUL-22 02.39.36.835324 PM	19-JUL-22 02.39.34.000000 PM	1
Neena	19-JUL-22 01.46.17.766511 PM	-	1
Lex	19-JUL-22 01.46.17.766511 PM	-	1
Alexander	19-JUL-22 02.08.42.704652 PM	-	1
Bruce	19-JUL-22 02.07.54.846334 PM	-	1
David	19-JUL-22 02.07.54.846349 PM	-	1
Valli	19-JUL-22 02.39.36.835358 PM	19-JUL-22 02.39.34.000000 PM	1
Diana	19-JUL-22 02.07.54.846361 PM	-	1
Nancy	19-JUL-22 01.46.17.766511 PM	-	1
Daniel	19-JUL-22 02.07.54.846825 PM	-	1
John	19-JUL-22 01.46.17.766511 PM	-	1
Ismael	19-JUL-22 02.07.54.846372 PM	-	1
Jose Manuel	19-JUL-22 01.46.17.766511 PM	-	1
Luis	19-JUL-22 01.46.17.766511 PM	-	1
Den	19-JUL-22 02.07.54.846838 PM	-	1
Alexander	19-JUL-22 02.08.42.704734 PM	-	1
Shelli	19-JUL-22 02.39.36.835372 PM	19-JUL-22 02.39.34.000000 PM	1
Sigal	19-JUL-22 02.39.36.835384 PM	19-JUL-22 02.39.34.000000 PM	1
Guy	19-JUL-22 02.07.54.846397 PM	-	1
Karen	19-JUL-22 01.46.17.766511 PM	-	1
Matthew	19-JUL-22 01.46.17.766511 PM	-	1
Adam	19-JUL-22 02.39.20.124079 PM	19-JUL-22 02.39.19.000000 PM	1
Payam	19-JUL-22 02.39.36.835396 PM	19-JUL-22 02.39.34.000000 PM	1
Shanta	19-JUL-22 02.39.36.835410 PM	19-JUL-22 02.39.34.000000 PM	1
Kevin	19-JUL-22 01.46.17.766511 PM	-	1
Julia	19-JUL-22 01.46.17.766511 PM	-	1
Irene	19-JUL-22 02.07.54.846420 PM	-	1
James	19-JUL-22 01.46.17.766511 PM	-	1
Steven	19-JUL-22 02.39.36.835422 PM	19-JUL-22 02.39.34.000000 PM	1
Laura	19-JUL-22 01.46.17.766511 PM	-	1
Mozhe	19-JUL-22 01.46.17.766511 PM	-	1
James	19-JUL-22 01.46.17.766511 PM	-	1
TJ	19-JUL-22 02.39.36.835434 PM	19-JUL-22 02.39.34.000000 PM	1
Jason	19-JUL-22 01.46.17.766511 PM	-	1
Michael	19-JUL-22 01.46.17.766511 PM	-	1
Ki	19-JUL-22 01.46.17.766511 PM	-	1
Hazel	19-JUL-22 02.07.54.846432 PM	-	1
Renske	19-JUL-22 02.39.36.835446 PM	19-JUL-22 02.39.34.000000 PM	1
Stephen	19-JUL-22 02.39.36.835457 PM	19-JUL-22 02.39.34.000000 PM	1
John	19-JUL-22 01.46.17.766511 PM	-	1
Joshua	19-JUL-22 01.46.17.766511 PM	-	1
Trenna	19-JUL-22 02.39.36.835469 PM	19-JUL-22 02.39.34.000000 PM	1
Curtis	19-JUL-22 02.07.54.846444 PM	-	1
Randall	19-JUL-22 02.39.36.835480 PM	19-JUL-22 02.39.34.000000 PM	1
Peter	19-JUL-22 02.39.36.835492 PM	19-JUL-22 02.39.34.000000 PM	1
John	19-JUL-22 01.46.17.766511 PM	-	1
Karen	19-JUL-22 01.46.17.766511 PM	-	1
Alberto	19-JUL-22 02.08.42.704776 PM	-	1
Gerald	19-JUL-22 02.07.54.846467 PM	-	1
Eleni	19-JUL-22 02.07.54.846479 PM	-	1

Rows 1 - 50. More rows exist.

Statement 185

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e

FIRST_NAME	VERSIONS_STARTTIME
Sarah	19-JUL-22 02.39.34.000000 PM
Vance	19-JUL-22 02.39.34.000000 PM
Samuel	19-JUL-22 02.39.34.000000 PM
Randall	19-JUL-22 02.39.34.000000 PM
Timothy	19-JUL-22 02.39.34.000000 PM
Winston	19-JUL-22 02.39.34.000000 PM
Sundita	19-JUL-22 02.39.34.000000 PM
William	19-JUL-22 02.39.34.000000 PM
Tayler	19-JUL-22 02.39.34.000000 PM
Sundar	19-JUL-22 02.39.34.000000 PM
Sarath	19-JUL-22 02.39.34.000000 PM
Peter	19-JUL-22 02.39.34.000000 PM
Peter	19-JUL-22 02.39.34.000000 PM
Peter	19-JUL-22 02.39.34.000000 PM
Randall	19-JUL-22 02.39.34.000000 PM
Trenna	19-JUL-22 02.39.34.000000 PM
Stephen	19-JUL-22 02.39.34.000000 PM
Renske	19-JUL-22 02.39.34.000000 PM
TJ	19-JUL-22 02.39.34.000000 PM
Steven	19-JUL-22 02.39.34.000000 PM
Shanta	19-JUL-22 02.39.34.000000 PM
Payam	19-JUL-22 02.39.34.000000 PM
Sigal	19-JUL-22 02.39.34.000000 PM
Shelli	19-JUL-22 02.39.34.000000 PM
Valli	19-JUL-22 02.39.34.000000 PM
Steven	19-JUL-22 02.39.34.000000 PM
Steven	-
Neena	-
Lex	-
Alexander	-
Bruce	-
David	-
Valli	-
Diana	-
Nancy	-
Daniel	-
John	-
Ismael	-
Jose Manuel	-
Luis	-
Den	-
Alexander	-
Shelli	-
Sigal	-
Guy	-
Karen	-
Matthew	-
Adam	-
Payam	-
Shanta	-

Rows 1 - 50. More rows exist.

Statement 186

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Adam	-
Alana	-
Alberto	-
Alexander	-
Alexander	-
Alexis	-
Allan	-
Alyssa	-
Amit	-
Anthony	-
Britney	-
Bruce	-
Charles	-
Christopher	-
Clara	-
Curtis	-
Daniel	-
Danielle	-
David	-
David	-
David	-
Den	-
Diana	-
Donald	-
Douglas	-
Eleni	-
Elizabeth	-
Ellen	-
Gerald	-
Girard	-
Guy	-
Harrison	-
Hazel	-
Hermann	-
Irene	-
Ismael	-
Jack	-
James	-
James	-
Janette	-
Jason	-
Jean	-
Jennifer	-
Jennifer	-
John	-
John	-
John	-
Jonathon	-
Jose Manuel	-
Joshua	-

Rows 1 - 50. More rows exist.

Statement 187

update employees set salary = salary * 1.05 where first_name < 'JOHN'

36 row(s) updated.

Statement 188

commit

Statement processed.

Statement 189

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Adam	-
Alana	-
Alberto	-
Alexander	-
Alexander	-
Alexis	-
Allan	-
Alyssa	-
Amit	-
Anthony	-
Britney	-
Bruce	-
Charles	-
Christopher	-
Clara	-
Curtis	-
Daniel	-
Danielle	-
David	-
David	-
David	-
Den	-
Diana	-
Donald	-
Douglas	-
Eleni	-
Elizabeth	-
Ellen	-
Gerald	-
Girard	-
Guy	-
Harrison	-
Hazel	-
Hermann	-
Irene	-
Ismael	-
Jack	-
James	-
James	-
Janette	-
Jason	-
Jean	-
Jennifer	-
Jennifer	-
John	-
John	-
John	-
Jonathon	-
Jose Manuel	-
Joshua	-

Rows 1 - 50. More rows exist.

Statement 190

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Adam	19-JUL-22 02.50.19.000000 PM
Adam	-
Alana	19-JUL-22 02.50.19.000000 PM
Alana	-
Alberto	-
Alberto	19-JUL-22 02.50.19.000000 PM
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexis	19-JUL-22 02.50.19.000000 PM
Alexis	-
Allan	19-JUL-22 02.50.19.000000 PM
Allan	-
Alyssa	19-JUL-22 02.50.19.000000 PM
Alyssa	-
Amit	19-JUL-22 02.50.19.000000 PM
Amit	-
Anthony	19-JUL-22 02.50.19.000000 PM
Anthony	-
Britney	19-JUL-22 02.50.19.000000 PM
Britney	-
Bruce	19-JUL-22 02.50.19.000000 PM
Bruce	-
Charles	19-JUL-22 02.50.19.000000 PM
Charles	-
Christopher	-
Christopher	19-JUL-22 02.50.19.000000 PM
Clara	-
Clara	19-JUL-22 02.50.19.000000 PM
Curtis	-
Curtis	19-JUL-22 02.50.19.000000 PM
Daniel	-
Daniel	19-JUL-22 02.50.19.000000 PM
Danielle	19-JUL-22 02.50.19.000000 PM
Danielle	-
David	-
David	-
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	-
Den	19-JUL-22 02.50.19.000000 PM
Den	-
Diana	-
Diana	19-JUL-22 02.50.19.000000 PM
Donald	-
Donald	19-JUL-22 02.50.19.000000 PM
Douglas	-
Douglas	19-JUL-22 02.50.19.000000 PM

Rows 1 - 50. More rows exist.

Statement 191

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Adam	19-JUL-22 02.50.19.000000 PM
Adam	-
Alana	19-JUL-22 02.50.19.000000 PM
Alana	-
Alberto	-
Alberto	19-JUL-22 02.50.19.000000 PM
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexis	19-JUL-22 02.50.19.000000 PM
Alexis	-
Allan	19-JUL-22 02.50.19.000000 PM
Allan	-
Alyssa	19-JUL-22 02.50.19.000000 PM
Alyssa	-
Amit	19-JUL-22 02.50.19.000000 PM
Amit	-
Anthony	19-JUL-22 02.50.19.000000 PM
Anthony	-
Britney	19-JUL-22 02.50.19.000000 PM
Britney	-
Bruce	19-JUL-22 02.50.19.000000 PM
Bruce	-
Charles	19-JUL-22 02.50.19.000000 PM
Charles	-
Christopher	-
Christopher	19-JUL-22 02.50.19.000000 PM
Clara	-
Clara	19-JUL-22 02.50.19.000000 PM
Curtis	-
Curtis	19-JUL-22 02.50.19.000000 PM
Daniel	-
Daniel	19-JUL-22 02.50.19.000000 PM
Danielle	19-JUL-22 02.50.19.000000 PM
Danielle	-
David	-
David	-
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	-
Den	19-JUL-22 02.50.19.000000 PM
Den	-
Diana	-
Diana	19-JUL-22 02.50.19.000000 PM
Donald	-
Donald	19-JUL-22 02.50.19.000000 PM
Douglas	-
Douglas	19-JUL-22 02.50.19.000000 PM

Rows 1 - 50. More rows exist.

Statement 192

insert into employees (employee_id, first_name, last_name, email, hire_date, job_id) 
values (18192,'Bo', 'Jansen', 'ljansen@dome.dom',sysdate, 'AD_VP')

ORA-00001: unique constraint (SQL_DPBOKFMKXNSRHSHCCPNDFWZXJ.EMP_EMP_ID_PK) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

Statement 193

commit

Statement processed.

Statement 194

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Adam	19-JUL-22 02.50.19.000000 PM
Adam	-
Alana	19-JUL-22 02.50.19.000000 PM
Alana	-
Alberto	-
Alberto	19-JUL-22 02.50.19.000000 PM
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexis	19-JUL-22 02.50.19.000000 PM
Alexis	-
Allan	19-JUL-22 02.50.19.000000 PM
Allan	-
Alyssa	19-JUL-22 02.50.19.000000 PM
Alyssa	-
Amit	19-JUL-22 02.50.19.000000 PM
Amit	-
Anthony	19-JUL-22 02.50.19.000000 PM
Anthony	-
Britney	19-JUL-22 02.50.19.000000 PM
Britney	-
Bruce	19-JUL-22 02.50.19.000000 PM
Bruce	-
Charles	19-JUL-22 02.50.19.000000 PM
Charles	-
Christopher	-
Christopher	19-JUL-22 02.50.19.000000 PM
Clara	-
Clara	19-JUL-22 02.50.19.000000 PM
Curtis	-
Curtis	19-JUL-22 02.50.19.000000 PM
Daniel	-
Daniel	19-JUL-22 02.50.19.000000 PM
Danielle	19-JUL-22 02.50.19.000000 PM
Danielle	-
David	-
David	-
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	-
Den	19-JUL-22 02.50.19.000000 PM
Den	-
Diana	-
Diana	19-JUL-22 02.50.19.000000 PM
Donald	-
Donald	19-JUL-22 02.50.19.000000 PM
Douglas	-
Douglas	19-JUL-22 02.50.19.000000 PM

Rows 1 - 50. More rows exist.

Statement 195

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Adam	19-JUL-22 02.50.19.000000 PM
Adam	-
Alana	19-JUL-22 02.50.19.000000 PM
Alana	-
Alberto	-
Alberto	19-JUL-22 02.50.19.000000 PM
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexis	19-JUL-22 02.50.19.000000 PM
Alexis	-
Allan	19-JUL-22 02.50.19.000000 PM
Allan	-
Alyssa	19-JUL-22 02.50.19.000000 PM
Alyssa	-
Amit	19-JUL-22 02.50.19.000000 PM
Amit	-
Anthony	19-JUL-22 02.50.19.000000 PM
Anthony	-
Britney	19-JUL-22 02.50.19.000000 PM
Britney	-
Bruce	19-JUL-22 02.50.19.000000 PM
Bruce	-
Charles	19-JUL-22 02.50.19.000000 PM
Charles	-
Christopher	-
Christopher	19-JUL-22 02.50.19.000000 PM
Clara	-
Clara	19-JUL-22 02.50.19.000000 PM
Curtis	-
Curtis	19-JUL-22 02.50.19.000000 PM
Daniel	-
Daniel	19-JUL-22 02.50.19.000000 PM
Danielle	19-JUL-22 02.50.19.000000 PM
Danielle	-
David	-
David	-
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	-
Den	19-JUL-22 02.50.19.000000 PM
Den	-
Diana	-
Diana	19-JUL-22 02.50.19.000000 PM
Donald	-
Donald	19-JUL-22 02.50.19.000000 PM
Douglas	-
Douglas	19-JUL-22 02.50.19.000000 PM

Rows 1 - 50. More rows exist.

Statement 196

insert into employees (employee_id, first_name, last_name, email, hire_date, job_id) 
values (18192,'Bo', 'Jansen', 'ljansen@dome.dom',sysdate, 'AD_VP')

ORA-00001: unique constraint (SQL_DPBOKFMKXNSRHSHCCPNDFWZXJ.EMP_EMP_ID_PK) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

Statement 197

commit

Statement processed.

Statement 198

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Adam	19-JUL-22 02.50.19.000000 PM
Adam	-
Alana	19-JUL-22 02.50.19.000000 PM
Alana	-
Alberto	-
Alberto	19-JUL-22 02.50.19.000000 PM
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexis	19-JUL-22 02.50.19.000000 PM
Alexis	-
Allan	19-JUL-22 02.50.19.000000 PM
Allan	-
Alyssa	19-JUL-22 02.50.19.000000 PM
Alyssa	-
Amit	19-JUL-22 02.50.19.000000 PM
Amit	-
Anthony	19-JUL-22 02.50.19.000000 PM
Anthony	-
Britney	19-JUL-22 02.50.19.000000 PM
Britney	-
Bruce	19-JUL-22 02.50.19.000000 PM
Bruce	-
Charles	19-JUL-22 02.50.19.000000 PM
Charles	-
Christopher	-
Christopher	19-JUL-22 02.50.19.000000 PM
Clara	-
Clara	19-JUL-22 02.50.19.000000 PM
Curtis	-
Curtis	19-JUL-22 02.50.19.000000 PM
Daniel	-
Daniel	19-JUL-22 02.50.19.000000 PM
Danielle	19-JUL-22 02.50.19.000000 PM
Danielle	-
David	-
David	-
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	-
Den	19-JUL-22 02.50.19.000000 PM
Den	-
Diana	-
Diana	19-JUL-22 02.50.19.000000 PM
Donald	-
Donald	19-JUL-22 02.50.19.000000 PM
Douglas	-
Douglas	19-JUL-22 02.50.19.000000 PM

Rows 1 - 50. More rows exist.

Statement 199

insert into employees (employee_id, first_name, last_name, email, hire_date, job_id) 
values (181922,'Chris', 'Jansen', 'ljansen@dome.dom',sysdate, 'AD_VP')

ORA-00001: unique constraint (SQL_DPBOKFMKXNSRHSHCCPNDFWZXJ.EMP_EMAIL_UK) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

Statement 200

commit

Statement processed.

Statement 201

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Adam	19-JUL-22 02.50.19.000000 PM
Adam	-
Alana	19-JUL-22 02.50.19.000000 PM
Alana	-
Alberto	-
Alberto	19-JUL-22 02.50.19.000000 PM
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexis	19-JUL-22 02.50.19.000000 PM
Alexis	-
Allan	19-JUL-22 02.50.19.000000 PM
Allan	-
Alyssa	19-JUL-22 02.50.19.000000 PM
Alyssa	-
Amit	19-JUL-22 02.50.19.000000 PM
Amit	-
Anthony	19-JUL-22 02.50.19.000000 PM
Anthony	-
Britney	19-JUL-22 02.50.19.000000 PM
Britney	-
Bruce	19-JUL-22 02.50.19.000000 PM
Bruce	-
Charles	19-JUL-22 02.50.19.000000 PM
Charles	-
Christopher	-
Christopher	19-JUL-22 02.50.19.000000 PM
Clara	-
Clara	19-JUL-22 02.50.19.000000 PM
Curtis	-
Curtis	19-JUL-22 02.50.19.000000 PM
Daniel	-
Daniel	19-JUL-22 02.50.19.000000 PM
Danielle	19-JUL-22 02.50.19.000000 PM
Danielle	-
David	-
David	-
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	-
Den	19-JUL-22 02.50.19.000000 PM
Den	-
Diana	-
Diana	19-JUL-22 02.50.19.000000 PM
Donald	-
Donald	19-JUL-22 02.50.19.000000 PM
Douglas	-
Douglas	19-JUL-22 02.50.19.000000 PM

Rows 1 - 50. More rows exist.

Statement 202

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Adam	19-JUL-22 02.50.19.000000 PM
Adam	-
Alana	19-JUL-22 02.50.19.000000 PM
Alana	-
Alberto	-
Alberto	19-JUL-22 02.50.19.000000 PM
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexis	19-JUL-22 02.50.19.000000 PM
Alexis	-
Allan	19-JUL-22 02.50.19.000000 PM
Allan	-
Alyssa	19-JUL-22 02.50.19.000000 PM
Alyssa	-
Amit	19-JUL-22 02.50.19.000000 PM
Amit	-
Anthony	19-JUL-22 02.50.19.000000 PM
Anthony	-
Britney	19-JUL-22 02.50.19.000000 PM
Britney	-
Bruce	19-JUL-22 02.50.19.000000 PM
Bruce	-
Charles	19-JUL-22 02.50.19.000000 PM
Charles	-
Christopher	-
Christopher	19-JUL-22 02.50.19.000000 PM
Clara	-
Clara	19-JUL-22 02.50.19.000000 PM
Curtis	-
Curtis	19-JUL-22 02.50.19.000000 PM
Daniel	-
Daniel	19-JUL-22 02.50.19.000000 PM
Danielle	19-JUL-22 02.50.19.000000 PM
Danielle	-
David	-
David	-
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	-
Den	19-JUL-22 02.50.19.000000 PM
Den	-
Diana	-
Diana	19-JUL-22 02.50.19.000000 PM
Donald	-
Donald	19-JUL-22 02.50.19.000000 PM
Douglas	-
Douglas	19-JUL-22 02.50.19.000000 PM

Rows 1 - 50. More rows exist.

Statement 203

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e     
where e.first_name like 'C%' 
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Charles	-
Charles	19-JUL-22 02.50.19.000000 PM
Christopher	19-JUL-22 02.50.19.000000 PM
Christopher	-
Clara	-
Clara	19-JUL-22 02.50.19.000000 PM
Curtis	-
Curtis	19-JUL-22 02.50.19.000000 PM

8 rows selected.

Statement 204

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e     
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Adam	19-JUL-22 02.50.19.000000 PM
Adam	-
Alana	19-JUL-22 02.50.19.000000 PM
Alana	-
Alberto	-
Alberto	19-JUL-22 02.50.19.000000 PM
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexis	19-JUL-22 02.50.19.000000 PM
Alexis	-
Allan	19-JUL-22 02.50.19.000000 PM
Allan	-
Alyssa	19-JUL-22 02.50.19.000000 PM
Alyssa	-
Amit	19-JUL-22 02.50.19.000000 PM
Amit	-
Anthony	19-JUL-22 02.50.19.000000 PM
Anthony	-
Britney	19-JUL-22 02.50.19.000000 PM
Britney	-
Bruce	19-JUL-22 02.50.19.000000 PM
Bruce	-
Charles	19-JUL-22 02.50.19.000000 PM
Charles	-
Christopher	-
Christopher	19-JUL-22 02.50.19.000000 PM
Clara	-
Clara	19-JUL-22 02.50.19.000000 PM
Curtis	-
Curtis	19-JUL-22 02.50.19.000000 PM
Daniel	-
Daniel	19-JUL-22 02.50.19.000000 PM
Danielle	19-JUL-22 02.50.19.000000 PM
Danielle	-
David	-
David	-
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	-
Den	19-JUL-22 02.50.19.000000 PM
Den	-
Diana	-
Diana	19-JUL-22 02.50.19.000000 PM
Donald	-
Donald	19-JUL-22 02.50.19.000000 PM
Douglas	-
Douglas	19-JUL-22 02.50.19.000000 PM

Rows 1 - 50. More rows exist.

Statement 205

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 5/24/60 AND SYSTIMESTAMP e     
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Adam	19-JUL-22 02.50.19.000000 PM
Adam	-
Alana	19-JUL-22 02.50.19.000000 PM
Alana	-
Alberto	-
Alberto	19-JUL-22 02.50.19.000000 PM
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexis	19-JUL-22 02.50.19.000000 PM
Alexis	-
Allan	19-JUL-22 02.50.19.000000 PM
Allan	-
Alyssa	19-JUL-22 02.50.19.000000 PM
Alyssa	-
Amit	19-JUL-22 02.50.19.000000 PM
Amit	-
Anthony	19-JUL-22 02.50.19.000000 PM
Anthony	-
Britney	19-JUL-22 02.50.19.000000 PM
Britney	-
Bruce	19-JUL-22 02.50.19.000000 PM
Bruce	-
Charles	19-JUL-22 02.50.19.000000 PM
Charles	-
Christopher	-
Christopher	19-JUL-22 02.50.19.000000 PM
Clara	-
Clara	19-JUL-22 02.50.19.000000 PM
Curtis	-
Curtis	19-JUL-22 02.50.19.000000 PM
Daniel	-
Daniel	19-JUL-22 02.50.19.000000 PM
Danielle	19-JUL-22 02.50.19.000000 PM
Danielle	-
David	-
David	-
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	-
Den	19-JUL-22 02.50.19.000000 PM
Den	-
Diana	-
Diana	19-JUL-22 02.50.19.000000 PM
Donald	-
Donald	19-JUL-22 02.50.19.000000 PM
Douglas	-
Douglas	19-JUL-22 02.50.19.000000 PM

Rows 1 - 50. More rows exist.

Statement 206

insert into employees (employee_id, first_name, last_name, email, hire_date, job_id) 
values (18117,'Lars', 'Elstrup', 'lelstrup@dome.dom',sysdate, 'AD_VP')

ORA-00001: unique constraint (SQL_DPBOKFMKXNSRHSHCCPNDFWZXJ.EMP_EMAIL_UK) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

Statement 207

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 5/24/60 AND SYSTIMESTAMP e     
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Adam	-
Alana	-
Alberto	-
Alexander	-
Alexander	-
Alexis	-
Allan	-
Alyssa	-
Amit	-
Anthony	-
Britney	-
Bruce	-
Charles	-
Christopher	-
Clara	-
Curtis	-
Daniel	-
Danielle	-
David	-
David	-
David	-
Den	-
Diana	-
Donald	-
Douglas	-
Eleni	-
Elizabeth	-
Ellen	-
Gerald	-
Girard	-
Guy	-
Harrison	-
Hazel	-
Hermann	-
Irene	-
Ismael	-
Jack	-
James	-
James	-
Janette	-
Jason	-
Jean	-
Jennifer	-
Jennifer	-
John	-
John	-
John	-
Jonathon	-
Jose Manuel	-
Joshua	-

Rows 1 - 50. More rows exist.

Statement 208

insert into employees (employee_id, first_name, last_name, email, hire_date, job_id) 
values (18117,'Aart', 'Elstrup', 'aalelstrup@dome.dom',sysdate, 'AD_VP')

1 row(s) inserted.

Statement 209

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 5/24/60 AND SYSTIMESTAMP e     
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Aart	19-JUL-22 02.55.31.000000 PM
Adam	-
Alana	-
Alberto	-
Alexander	-
Alexander	-
Alexis	-
Allan	-
Alyssa	-
Amit	-
Anthony	-
Britney	-
Bruce	-
Charles	-
Christopher	-
Clara	-
Curtis	-
Daniel	-
Danielle	-
David	-
David	-
David	-
Den	-
Diana	-
Donald	-
Douglas	-
Eleni	-
Elizabeth	-
Ellen	-
Gerald	-
Girard	-
Guy	-
Harrison	-
Hazel	-
Hermann	-
Irene	-
Ismael	-
Jack	-
James	-
James	-
Janette	-
Jason	-
Jean	-
Jennifer	-
Jennifer	-
John	-
John	-
John	-
Jonathon	-
Jose Manuel	-

Rows 1 - 50. More rows exist.

Statement 210

commit

Statement processed.

Statement 211

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 15/24/60 AND SYSTIMESTAMP e     
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Aart	19-JUL-22 02.55.31.000000 PM
Adam	-
Adam	19-JUL-22 02.50.19.000000 PM
Alana	-
Alana	19-JUL-22 02.50.19.000000 PM
Alberto	-
Alberto	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexander	-
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	19-JUL-22 02.50.19.000000 PM
Alexis	-
Alexis	19-JUL-22 02.50.19.000000 PM
Allan	19-JUL-22 02.50.19.000000 PM
Allan	-
Alyssa	19-JUL-22 02.50.19.000000 PM
Alyssa	-
Amit	19-JUL-22 02.50.19.000000 PM
Amit	-
Anthony	19-JUL-22 02.50.19.000000 PM
Anthony	-
Britney	-
Britney	19-JUL-22 02.50.19.000000 PM
Bruce	19-JUL-22 02.50.19.000000 PM
Bruce	-
Charles	19-JUL-22 02.50.19.000000 PM
Charles	-
Christopher	19-JUL-22 02.50.19.000000 PM
Christopher	-
Clara	19-JUL-22 02.50.19.000000 PM
Clara	-
Curtis	19-JUL-22 02.50.19.000000 PM
Curtis	-
Daniel	19-JUL-22 02.50.19.000000 PM
Daniel	-
Danielle	19-JUL-22 02.50.19.000000 PM
Danielle	-
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	-
David	19-JUL-22 02.50.19.000000 PM
David	-
David	-
Den	19-JUL-22 02.50.19.000000 PM
Den	-
Diana	-
Diana	19-JUL-22 02.50.19.000000 PM
Donald	-
Donald	19-JUL-22 02.50.19.000000 PM
Douglas	-

Rows 1 - 50. More rows exist.

Statement 212

select e.first_name 
,      e.versions_starttime 
, SCN_TO_TIMESTAMP(MAX(ORA_ROWSCN))  
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 15/24/60 AND SYSTIMESTAMP e     
order by 1

ORA-00904: "ORA_ROWSCN": invalid identifier

Statement 213

select e.first_name 
,      e.versions_starttime 
, SCN_TO_TIMESTAMP(VERSIONS_STARTSCN) 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 15/24/60 AND SYSTIMESTAMP e     
order by 1

ORA-01405: fetched column value is NULL

Statement 214

select e.first_name 
,      e.versions_starttime 
,VERSIONS_STARTSCN 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 15/24/60 AND SYSTIMESTAMP e     
order by 1

FIRST_NAME	VERSIONS_STARTTIME	VERSIONS_STARTSCN
Aart	19-JUL-22 02.55.31.000000 PM	130114915318
Adam	-	-
Adam	19-JUL-22 02.50.19.000000 PM	130114816298
Alana	-	-
Alana	19-JUL-22 02.50.19.000000 PM	130114816298
Alberto	-	-
Alberto	19-JUL-22 02.50.19.000000 PM	130114816298
Alexander	-	-
Alexander	-	-
Alexander	19-JUL-22 02.50.19.000000 PM	130114816298
Alexander	19-JUL-22 02.50.19.000000 PM	130114816298
Alexis	-	-
Alexis	19-JUL-22 02.50.19.000000 PM	130114816298
Allan	19-JUL-22 02.50.19.000000 PM	130114816298
Allan	-	-
Alyssa	19-JUL-22 02.50.19.000000 PM	130114816298
Alyssa	-	-
Amit	19-JUL-22 02.50.19.000000 PM	130114816298
Amit	-	-
Anthony	19-JUL-22 02.50.19.000000 PM	130114816298
Anthony	-	-
Britney	-	-
Britney	19-JUL-22 02.50.19.000000 PM	130114816298
Bruce	19-JUL-22 02.50.19.000000 PM	130114816298
Bruce	-	-
Charles	19-JUL-22 02.50.19.000000 PM	130114816298
Charles	-	-
Christopher	19-JUL-22 02.50.19.000000 PM	130114816298
Christopher	-	-
Clara	19-JUL-22 02.50.19.000000 PM	130114816298
Clara	-	-
Curtis	19-JUL-22 02.50.19.000000 PM	130114816298
Curtis	-	-
Daniel	19-JUL-22 02.50.19.000000 PM	130114816298
Daniel	-	-
Danielle	19-JUL-22 02.50.19.000000 PM	130114816298
Danielle	-	-
David	19-JUL-22 02.50.19.000000 PM	130114816298
David	19-JUL-22 02.50.19.000000 PM	130114816298
David	-	-
David	19-JUL-22 02.50.19.000000 PM	130114816298
David	-	-
David	-	-
Den	19-JUL-22 02.50.19.000000 PM	130114816298
Den	-	-
Diana	-	-
Diana	19-JUL-22 02.50.19.000000 PM	130114816298
Donald	-	-
Donald	19-JUL-22 02.50.19.000000 PM	130114816298
Douglas	-	-

Rows 1 - 50. More rows exist.

Statement 215

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 15/24/60 AND SYSTIMESTAMP e

FIRST_NAME	VERSIONS_STARTTIME
Den	19-JUL-22 02.50.19.000000 PM
Daniel	19-JUL-22 02.50.19.000000 PM
Charles	19-JUL-22 02.50.19.000000 PM
Elizabeth	19-JUL-22 02.50.19.000000 PM
Alana	19-JUL-22 02.50.19.000000 PM
Britney	19-JUL-22 02.50.19.000000 PM
Anthony	19-JUL-22 02.50.19.000000 PM
Alexis	19-JUL-22 02.50.19.000000 PM
Girard	19-JUL-22 02.50.19.000000 PM
Alyssa	19-JUL-22 02.50.19.000000 PM
Ellen	19-JUL-22 02.50.19.000000 PM
Harrison	19-JUL-22 02.50.19.000000 PM
Amit	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
Danielle	19-JUL-22 02.50.19.000000 PM
Clara	19-JUL-22 02.50.19.000000 PM
Allan	19-JUL-22 02.50.19.000000 PM
Christopher	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
Eleni	19-JUL-22 02.50.19.000000 PM
Gerald	19-JUL-22 02.50.19.000000 PM
Alberto	19-JUL-22 02.50.19.000000 PM
Curtis	19-JUL-22 02.50.19.000000 PM
Hazel	19-JUL-22 02.50.19.000000 PM
Irene	19-JUL-22 02.50.19.000000 PM
Adam	19-JUL-22 02.50.19.000000 PM
Guy	19-JUL-22 02.50.19.000000 PM
Alexander	19-JUL-22 02.50.19.000000 PM
Ismael	19-JUL-22 02.50.19.000000 PM
Diana	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
Bruce	19-JUL-22 02.50.19.000000 PM
Alexander	19-JUL-22 02.50.19.000000 PM
Steven	-
Neena	-
Lex	-
Alexander	-
Bruce	-
David	-
Valli	-
Diana	-
Nancy	-
Daniel	-
John	-
Ismael	-
Jose Manuel	-
Luis	-
Den	-
Alexander	-
Shelli	-

Rows 1 - 50. More rows exist.

Statement 216

select e.first_name 
,      e.versions_starttime 
from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 15/24/60 AND SYSTIMESTAMP e     
order by 1

FIRST_NAME	VERSIONS_STARTTIME
Aart	19-JUL-22 02.55.31.000000 PM
Adam	-
Adam	19-JUL-22 02.50.19.000000 PM
Alana	-
Alana	19-JUL-22 02.50.19.000000 PM
Alberto	-
Alberto	19-JUL-22 02.50.19.000000 PM
Alexander	-
Alexander	-
Alexander	19-JUL-22 02.50.19.000000 PM
Alexander	19-JUL-22 02.50.19.000000 PM
Alexis	-
Alexis	19-JUL-22 02.50.19.000000 PM
Allan	19-JUL-22 02.50.19.000000 PM
Allan	-
Alyssa	19-JUL-22 02.50.19.000000 PM
Alyssa	-
Amit	19-JUL-22 02.50.19.000000 PM
Amit	-
Anthony	19-JUL-22 02.50.19.000000 PM
Anthony	-
Britney	-
Britney	19-JUL-22 02.50.19.000000 PM
Bruce	19-JUL-22 02.50.19.000000 PM
Bruce	-
Charles	19-JUL-22 02.50.19.000000 PM
Charles	-
Christopher	19-JUL-22 02.50.19.000000 PM
Christopher	-
Clara	19-JUL-22 02.50.19.000000 PM
Clara	-
Curtis	19-JUL-22 02.50.19.000000 PM
Curtis	-
Daniel	19-JUL-22 02.50.19.000000 PM
Daniel	-
Danielle	19-JUL-22 02.50.19.000000 PM
Danielle	-
David	19-JUL-22 02.50.19.000000 PM
David	19-JUL-22 02.50.19.000000 PM
David	-
David	19-JUL-22 02.50.19.000000 PM
David	-
David	-
Den	19-JUL-22 02.50.19.000000 PM
Den	-
Diana	-
Diana	19-JUL-22 02.50.19.000000 PM
Donald	-
Donald	19-JUL-22 02.50.19.000000 PM
Douglas	-

Rows 1 - 50. More rows exist.

Statement 217

select * 
 
from ( select e.first_name 
 
       ,      e.versions_starttime 
 
       ,      row_number() over (partition by e.employee_id order by e.versions_starttime) rn 
 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP – 1 AND SYSTIMESTAMP e      
 
) 
 
where rn = 1

ORA-00911: invalid character

Statement 218

select *  
from ( select e.first_name  
       ,      e.versions_starttime  
       ,      row_number() over (patition by e.employee_id order by e.versions_starttime) rn 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP – 1 AND SYSTIMESTAMP e      
) 
where rn = 1

ORA-00907: missing right parenthesis

Statement 219

select *  
from ( select e.first_name  
       ,      e.versions_starttime  
       ,      row_number() over (partition by e.employee_id order by e.versions_starttime) rn 
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP – 1 AND SYSTIMESTAMP e      
) 
where rn = 1

ORA-00911: invalid character

Statement 220

select * 
from ( select e.first_name 
       ,      e.last_date_modified  
       ,      e.versions_starttime 
       ,      row_number() over (partition by e.employee_id order by e.versions_starttime) rn 
       from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
) 
where rn = 1

FIRST_NAME	LAST_DATE_MODIFIED	VERSIONS_STARTTIME	RN
Steven	19-JUL-22 02.39.36.835324 PM	-	1
Neena	19-JUL-22 01.46.17.766511 PM	-	1
Lex	19-JUL-22 01.46.17.766511 PM	-	1
Alexander	19-JUL-22 02.50.19.693092 PM	-	1
Bruce	19-JUL-22 02.50.19.693132 PM	-	1
David	19-JUL-22 02.50.19.693147 PM	-	1
Valli	19-JUL-22 02.39.36.835358 PM	-	1
Diana	19-JUL-22 02.50.19.693159 PM	-	1
Nancy	19-JUL-22 01.46.17.766511 PM	-	1
Daniel	19-JUL-22 02.50.19.693566 PM	-	1
John	19-JUL-22 01.46.17.766511 PM	-	1
Ismael	19-JUL-22 02.50.19.693171 PM	-	1
Jose Manuel	19-JUL-22 01.46.17.766511 PM	-	1
Luis	19-JUL-22 01.46.17.766511 PM	-	1
Den	19-JUL-22 02.50.19.693579 PM	-	1
Alexander	19-JUL-22 02.50.19.693184 PM	-	1
Shelli	19-JUL-22 02.39.36.835372 PM	-	1
Sigal	19-JUL-22 02.39.36.835384 PM	-	1
Guy	19-JUL-22 02.50.19.693195 PM	-	1
Karen	19-JUL-22 01.46.17.766511 PM	-	1
Matthew	19-JUL-22 01.46.17.766511 PM	-	1
Adam	19-JUL-22 02.50.19.693207 PM	-	1
Payam	19-JUL-22 02.39.36.835396 PM	-	1
Shanta	19-JUL-22 02.39.36.835410 PM	-	1
Kevin	19-JUL-22 01.46.17.766511 PM	-	1
Julia	19-JUL-22 01.46.17.766511 PM	-	1
Irene	19-JUL-22 02.50.19.693219 PM	-	1
James	19-JUL-22 01.46.17.766511 PM	-	1
Steven	19-JUL-22 02.39.36.835422 PM	-	1
Laura	19-JUL-22 01.46.17.766511 PM	-	1
Mozhe	19-JUL-22 01.46.17.766511 PM	-	1
James	19-JUL-22 01.46.17.766511 PM	-	1
TJ	19-JUL-22 02.39.36.835434 PM	-	1
Jason	19-JUL-22 01.46.17.766511 PM	-	1
Michael	19-JUL-22 01.46.17.766511 PM	-	1
Ki	19-JUL-22 01.46.17.766511 PM	-	1
Hazel	19-JUL-22 02.50.19.693231 PM	-	1
Renske	19-JUL-22 02.39.36.835446 PM	-	1
Stephen	19-JUL-22 02.39.36.835457 PM	-	1
John	19-JUL-22 01.46.17.766511 PM	-	1
Joshua	19-JUL-22 01.46.17.766511 PM	-	1
Trenna	19-JUL-22 02.39.36.835469 PM	-	1
Curtis	19-JUL-22 02.50.19.693242 PM	-	1
Randall	19-JUL-22 02.39.36.835480 PM	-	1
Peter	19-JUL-22 02.39.36.835492 PM	-	1
John	19-JUL-22 01.46.17.766511 PM	-	1
Karen	19-JUL-22 01.46.17.766511 PM	-	1
Alberto	19-JUL-22 02.50.19.693254 PM	-	1
Gerald	19-JUL-22 02.50.19.693266 PM	-	1
Eleni	19-JUL-22 02.50.19.693277 PM	-	1

Rows 1 - 50. More rows exist.

Statement 221

select * 
from ( select e.first_name 
       ,      e.versions_starttime 
       ,      row_number() over (partition by e.employee_id order by e.versions_starttime) rn 
       from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 10/24/60 AND SYSTIMESTAMP e      
) 
where rn = 1

FIRST_NAME	VERSIONS_STARTTIME	RN
Steven	-	1
Neena	-	1
Lex	-	1
Alexander	-	1
Bruce	-	1
David	-	1
Valli	-	1
Diana	-	1
Nancy	-	1
Daniel	-	1
John	-	1
Ismael	-	1
Jose Manuel	-	1
Luis	-	1
Den	-	1
Alexander	-	1
Shelli	-	1
Sigal	-	1
Guy	-	1
Karen	-	1
Matthew	-	1
Adam	-	1
Payam	-	1
Shanta	-	1
Kevin	-	1
Julia	-	1
Irene	-	1
James	-	1
Steven	-	1
Laura	-	1
Mozhe	-	1
James	-	1
TJ	-	1
Jason	-	1
Michael	-	1
Ki	-	1
Hazel	-	1
Renske	-	1
Stephen	-	1
John	-	1
Joshua	-	1
Trenna	-	1
Curtis	-	1
Randall	-	1
Peter	-	1
John	-	1
Karen	-	1
Alberto	-	1
Gerald	-	1
Eleni	-	1

Rows 1 - 50. More rows exist.

Statement 222

select * 
from ( select e.first_name 
       ,      e.versions_starttime 
       ,      row_number() over (partition by e.employee_id order by e.versions_starttime) rn 
       from   employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 15/24/60 AND SYSTIMESTAMP e      
) 
where rn = 1

FIRST_NAME	VERSIONS_STARTTIME	RN
Steven	-	1
Neena	-	1
Lex	-	1
Alexander	19-JUL-22 02.50.19.000000 PM	1
Bruce	19-JUL-22 02.50.19.000000 PM	1
David	19-JUL-22 02.50.19.000000 PM	1
Valli	-	1
Diana	19-JUL-22 02.50.19.000000 PM	1
Nancy	-	1
Daniel	19-JUL-22 02.50.19.000000 PM	1
John	-	1
Ismael	19-JUL-22 02.50.19.000000 PM	1
Jose Manuel	-	1
Luis	-	1
Den	19-JUL-22 02.50.19.000000 PM	1
Alexander	19-JUL-22 02.50.19.000000 PM	1
Shelli	-	1
Sigal	-	1
Guy	19-JUL-22 02.50.19.000000 PM	1
Karen	-	1
Matthew	-	1
Adam	19-JUL-22 02.50.19.000000 PM	1
Payam	-	1
Shanta	-	1
Kevin	-	1
Julia	-	1
Irene	19-JUL-22 02.50.19.000000 PM	1
James	-	1
Steven	-	1
Laura	-	1
Mozhe	-	1
James	-	1
TJ	-	1
Jason	-	1
Michael	-	1
Ki	-	1
Hazel	19-JUL-22 02.50.19.000000 PM	1
Renske	-	1
Stephen	-	1
John	-	1
Joshua	-	1
Trenna	-	1
Curtis	19-JUL-22 02.50.19.000000 PM	1
Randall	-	1
Peter	-	1
John	-	1
Karen	-	1
Alberto	19-JUL-22 02.50.19.000000 PM	1
Gerald	19-JUL-22 02.50.19.000000 PM	1
Eleni	19-JUL-22 02.50.19.000000 PM	1

Rows 1 - 50. More rows exist.

Flashback Versions Query and Pseudo Last Date Changed column

Additional Information