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.
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.
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.
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.
CREATE SEQUENCE locations_seq
START WITH 3300
INCREMENT BY 100
MAXVALUE 9900
NOCACHE
NOCYCLE
Sequence created.
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.
CREATE SEQUENCE departments_seq
START WITH 280
INCREMENT BY 10
MAXVALUE 9990
NOCACHE
NOCYCLE
Sequence created.
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.
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.
ALTER TABLE departments
ADD (CONSTRAINT dept_mgr_fk
FOREIGN KEY (manager_id)
REFERENCES employees (employee_id)
)
Table altered.
CREATE SEQUENCE employees_seq
START WITH 207
INCREMENT BY 1
NOCACHE
NOCYCLE
Sequence created.
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.
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.
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.
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.
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.
ALTER TABLE departments
DISABLE CONSTRAINT dept_mgr_fk
Table altered.
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.
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.
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.
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.
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.
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.
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.
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.
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.
ALTER TABLE departments
ENABLE CONSTRAINT dept_mgr_fk
Table altered.
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.
CREATE OR REPLACE TRIGGER secure_employees
BEFORE INSERT OR UPDATE OR DELETE ON employees
BEGIN
secure_dml;
END secure_employees;
Trigger created.
ALTER TRIGGER secure_employees DISABLE
Trigger altered.
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.
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.
COMMENT ON TABLE regions
IS 'Regions table that contains region numbers and names. Contains 4 rows; references with the Countries table.'
Statement processed.
COMMENT ON COLUMN regions.region_id
IS 'Primary key of regions table.'
Statement processed.
COMMENT ON COLUMN regions.region_name
IS 'Names of regions. Locations are in the countries of these regions.'
Statement processed.
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.
COMMENT ON COLUMN locations.location_id
IS 'Primary key of locations table'
Statement processed.
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.
COMMENT ON COLUMN locations.postal_code
IS 'Postal code of the location of an office, warehouse, or production site of a company. '
Statement processed.
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.
COMMENT ON COLUMN locations.state_province
IS 'State or Province where an office, warehouse, or production site of a company is located.'
Statement processed.
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.
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.
COMMENT ON COLUMN departments.department_id
IS 'Primary key column of departments table.'
Statement processed.
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.
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.
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.
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.
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.
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.
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.
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.
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.
COMMENT ON TABLE countries
IS 'country table. Contains 25 rows. References with locations table.'
Statement processed.
COMMENT ON COLUMN countries.country_id
IS 'Primary key of countries table.'
Statement processed.
COMMENT ON COLUMN countries.country_name
IS 'Country name'
Statement processed.
COMMENT ON COLUMN countries.region_id
IS 'Region ID for the country. Foreign key to region_id column in the departments table.'
Statement processed.
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.
COMMENT ON COLUMN jobs.job_id
IS 'Primary key of jobs table.'
Statement processed.
COMMENT ON COLUMN jobs.job_title
IS 'A not null column that shows job title, e.g. AD_VP, FI_ACCOUNTANT'
Statement processed.
COMMENT ON COLUMN jobs.min_salary
IS 'Minimum salary for a job title.'
Statement processed.
COMMENT ON COLUMN jobs.max_salary
IS 'Maximum salary for a job title'
Statement processed.
select count(*) from hr_employees
ORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
select count(*) from employees
COUNT(*) | 107 |
---|
alter table employees add (last_date_modified timestamp default systimestamp)
Table altered.
alter table employees add (last_date_modified timestamp default systimestamp)
ORA-01430: column being added already exists in tableMore Details: https://docs.oracle.com/error-help/db/ora-01430
CREATE OR REPLACE TRIGGER emp_upd_trg
BEFORE update ON employees
FOR EACH ROW
ENABLE
BEGIN
:new.last_date_modified:= systimestamp;
END;
Trigger created.
update employees set salary = salary * 1.05 where first_name < 'JOHN'
36 row(s) updated.
commit
Statement processed.
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 |
---|
update employees set salary = salary * 0.98 where first_name > 'Paul'
29 row(s) updated.
commit
Statement processed.
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 |
---|
select e.first_name, last_date_modified , versions_starttime
from employeesVERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 1
AND SYSTIMESTAMP
ORA-00933: SQL command not properly endedMore Details: https://docs.oracle.com/error-help/db/ora-00933
select e.first_name, last_date_modified , versions_starttime
from employeesVERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 1 AND SYSTIMESTAMP
ORA-00933: SQL command not properly endedMore Details: https://docs.oracle.com/error-help/db/ora-00933
select e.first_name, last_date_modified , versions_starttime
from employees VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - 1 AND SYSTIMESTAMP
ORA-00904: "E"."FIRST_NAME": invalid identifierMore Details: https://docs.oracle.com/error-help/db/ora-00904
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 changedMore Details: https://docs.oracle.com/error-help/db/ora-01466
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 changedMore Details: https://docs.oracle.com/error-help/db/ora-01466
update employees set salary = salary * 0.98 where first_name > 'Paul'
commit
ORA-00933: SQL command not properly endedMore Details: https://docs.oracle.com/error-help/db/ora-00933
update employees set salary = salary * 0.98 where first_name > 'Paul'
29 row(s) updated.
commit
Statement processed.
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 changedMore Details: https://docs.oracle.com/error-help/db/ora-01466
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 changedMore Details: https://docs.oracle.com/error-help/db/ora-01466
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 changedMore Details: https://docs.oracle.com/error-help/db/ora-01466
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 changedMore Details: https://docs.oracle.com/error-help/db/ora-01466
update employees set salary = salary * 1.05 where first_name < 'JOHN'
36 row(s) updated.
commit
Statement processed.
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 changedMore Details: https://docs.oracle.com/error-help/db/ora-01466
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 changedMore Details: https://docs.oracle.com/error-help/db/ora-01466
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 changedMore Details: https://docs.oracle.com/error-help/db/ora-01466
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 changedMore Details: https://docs.oracle.com/error-help/db/ora-01466
update employees set salary = salary * 0.98 where first_name = 'Adam'
1 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 0.98 where first_name = 'Alana'
1 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 0.98 where first_name = 'Alberto'
1 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 0.98 where first_name = 'Alexander'
2 row(s) updated.
commit
Statement processed.
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 changedMore Details: https://docs.oracle.com/error-help/db/ora-01466
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 NUMBERMore Details: https://docs.oracle.com/error-help/db/ora-00932
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 changedMore Details: https://docs.oracle.com/error-help/db/ora-01466
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 changedMore Details: https://docs.oracle.com/error-help/db/ora-01466
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 changedMore Details: https://docs.oracle.com/error-help/db/ora-01466
INSERT INTO employees VALUES (7369,'SMITH','CLERK',7902,to_date('17-12-1980','dd-mm-yyyy'),800,NULL,20)
ORA-00947: not enough valuesMore Details: https://docs.oracle.com/error-help/db/ora-00947
INSERT INTO employees VALUES (7499,'ALLEN','SALESMAN',7698,to_date('20-2-1981','dd-mm-yyyy'),1600,300,30)
ORA-00947: not enough valuesMore Details: https://docs.oracle.com/error-help/db/ora-00947
INSERT INTO employees VALUES (7521,'WARD','SALESMAN',7698,to_date('22-2-1981','dd-mm-yyyy'),1250,500,30)
ORA-00947: not enough valuesMore Details: https://docs.oracle.com/error-help/db/ora-00947
INSERT INTO employees VALUES (7566,'JONES','MANAGER',7839,to_date('2-4-1981','dd-mm-yyyy'),2975,NULL,20)
ORA-00947: not enough valuesMore Details: https://docs.oracle.com/error-help/db/ora-00947
desc employees
TABLE EMPLOYEES
Column | Null? | Type | EMPLOYEE_ID | NOT NULL | NUMBER(6,0) | FIRST_NAME | - | VARCHAR2(20) | LAST_NAME | NOT NULL | VARCHAR2(25) | 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) |
---|
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 |
---|
desc employees
TABLE EMPLOYEES
Column | Null? | Type | EMPLOYEE_ID | NOT NULL | NUMBER(6,0) | FIRST_NAME | - | VARCHAR2(20) | LAST_NAME | NOT NULL | VARCHAR2(25) | 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) |
---|
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 valuesMore Details: https://docs.oracle.com/error-help/db/ora-00947
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 existMore Details: https://docs.oracle.com/error-help/db/ora-00942
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.
commit
Statement processed.
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.
commit
Statement processed.
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 | - |
---|
update employees set salary = salary * 0.98 where first_name = 'Adam'
1 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 1.05 where first_name < 'JOHN'
36 row(s) updated.
commit
Statement processed.
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 changedMore Details: https://docs.oracle.com/error-help/db/ora-01466
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 |
---|
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 | - |
---|
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 | - |
---|
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 | - |
---|
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 | - |
---|
update employees set salary = salary * 1.05 where first_name < 'JOHN'
36 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 1.05 where first_name = 'ALEXANDER'
0 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 1.05 where first_name like 'ALEX%'
0 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 1.05 where first_name like 'AL%'
0 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 1.05 where first_name like 'A%'
10 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 1.05 where first_name ='LARS'
0 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 1.05 where first_name ='Lars'
1 row(s) updated.
commit
Statement processed.
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 |
---|
update employees set salary = salary * 0.98 where first_name = 'Adam'
1 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 0.98 where first_name = 'Alana'
1 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 0.98 where first_name > 'Paul'
29 row(s) updated.
commit
Statement processed.
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 |
---|
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 |
---|
update employees set salary = salary * 0.98 where first_name = 'Lars'
1 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 0.98 where first_name = 'Alana'
1 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 0.98 where first_name = 'Lars'
1 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 0.98 where first_name = 'Adam'
1 row(s) updated.
commit
Statement processed.
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 |
---|
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 |
---|
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
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 |
---|
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 |
---|
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 expressionMore Details: https://docs.oracle.com/error-help/db/ora-30052
show parameter undo_retention
no data found
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 expressionMore Details: https://docs.oracle.com/error-help/db/ora-30052
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 endedMore Details: https://docs.oracle.com/error-help/db/ora-00933
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 expressionMore Details: https://docs.oracle.com/error-help/db/ora-30052
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 |
---|
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
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 | - |
---|
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 | - |
---|
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 | - |
---|
update employees set salary = salary * 0.98 where first_name = 'Adam'
1 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 0.98 where first_name = 'Alana'
1 row(s) updated.
commit
Statement processed.
update employees set salary = salary * 0.98 where first_name > 'Paul'
29 row(s) updated.
commit
Statement processed.
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 |
---|
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 |
---|
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 |
---|
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 |
---|
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 | - |
---|
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 | - |
---|
update employees set salary = salary * 1.05 where first_name < 'JOHN'
36 row(s) updated.
commit
Statement processed.
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 | - |
---|
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 |
---|
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 |
---|
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 1721More Details: https://docs.oracle.com/error-help/db/ora-00001
commit
Statement processed.
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 |
---|
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 |
---|
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 1721More Details: https://docs.oracle.com/error-help/db/ora-00001
commit
Statement processed.
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 |
---|
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 1721More Details: https://docs.oracle.com/error-help/db/ora-00001
commit
Statement processed.
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 |
---|
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 |
---|
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 |
---|
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 |
---|
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 |
---|
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 1721More Details: https://docs.oracle.com/error-help/db/ora-00001
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 | - |
---|
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.
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 | - |
---|
commit
Statement processed.
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 | - |
---|
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 identifierMore Details: https://docs.oracle.com/error-help/db/ora-00904
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 NULLMore Details: https://docs.oracle.com/error-help/db/ora-01405
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 | - | - |
---|
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 | - |
---|
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 | - |
---|
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 characterMore Details: https://docs.oracle.com/error-help/db/ora-00911
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 parenthesisMore Details: https://docs.oracle.com/error-help/db/ora-00907
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 characterMore Details: https://docs.oracle.com/error-help/db/ora-00911
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 |
---|
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 |
---|
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 |
---|