EventTableWithData

View All Public Scripts Login to Run Script

Script Name EventTableWithData
Visibility Unlisted - anyone with the share link can access
Description EventTableWithData
Area SQL Analytics
Contributor shiekmoydheen@yahoo.com
Created Friday February 23, 2018

Statement 1

create table T_EVENT ( 
    EMP_ID                        NUMBER, 
    LOCATION_ID                   NUMBER, 
    EVENT_DATE                    DATE, 
    EVENT_TYPE                    VARCHAR2(4000), 
    CREATION_TRAN_SERIAL_NUMBER   NUMBER 
)

Table created.

Statement 2

CREATE UNIQUE INDEX PK_T_EVENT ON T_EVENT 
(EMP_ID, CREATION_TRAN_SERIAL_NUMBER)

Index created.

Statement 3

INSERT INTO T_EVENT_TMP VALUES(123, 111, TO_DATE('08/01/2016','mm/dd/yyyy'), 1, 1)

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 4

INSERT INTO T_EVENT_TMP VALUES(123, 222, TO_DATE('01/18/2017','mm/dd/yyyy'), 1, 2)

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 5

INSERT INTO T_EVENT_TMP VALUES(123, 222, TO_DATE('02/06/2017','mm/dd/yyyy'), 2, 3)

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 6

INSERT INTO T_EVENT_TMP VALUES(123, 111, TO_DATE('04/03/2017','mm/dd/yyyy'), 2, 4)

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 7

INSERT INTO T_EVENT_TMP VALUES(456, 333, TO_DATE('08/01/2016','mm/dd/yyyy'), 1, 5)

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 8

INSERT INTO T_EVENT_TMP VALUES(456, 444, TO_DATE('01/18/2017','mm/dd/yyyy'), 1, 6)

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 9

INSERT INTO T_EVENT_TMP VALUES(777, 111, TO_DATE('08/22/2016','mm/dd/yyyy'), 1, 7)

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 10

INSERT INTO T_EVENT_TMP VALUES(777, 222, TO_DATE('12/07/2016','mm/dd/yyyy'), 1, 8)

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 11

INSERT INTO T_EVENT_TMP VALUES(777, 111, TO_DATE('12/07/2016','mm/dd/yyyy'), 2, 9)

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 12

INSERT INTO T_EVENT_TMP VALUES(777, 222, TO_DATE('12/14/2016','mm/dd/yyyy'), 2, 10)

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 13

INSERT INTO T_EVENT_TMP VALUES(777, 333, TO_DATE('01/20/2017','mm/dd/yyyy'), 1, 11)

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 14

INSERT INTO T_EVENT_TMP VALUES(777, 333, TO_DATE('02/06/2017','mm/dd/yyyy'), 2, 12)

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 15

INSERT INTO T_EVENT_TMP VALUES(777, 111, TO_DATE('02/06/2017','mm/dd/yyyy'), 1, 13)

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 16

INSERT INTO T_EVENT_TMP VALUES(777, 111, TO_DATE('03/10/2017','mm/dd/yyyy'), 2, 14)

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 17

create table T_EVENT ( 
    EMP_ID                        NUMBER, 
    LOCATION_ID                   NUMBER, 
    EVENT_DATE                    DATE, 
    EVENT_TYPE                    VARCHAR2(4000), 
    CREATION_TRAN_SERIAL_NUMBER   NUMBER 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 18

CREATE UNIQUE INDEX PK_T_EVENT ON T_EVENT 
(EMP_ID, CREATION_TRAN_SERIAL_NUMBER)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 19

INSERT INTO T_EVENT VALUES(123, 111, TO_DATE('08/01/2016','mm/dd/yyyy'), 1, 1)

1 row(s) inserted.

Statement 20

INSERT INTO T_EVENT VALUES(123, 222, TO_DATE('01/18/2017','mm/dd/yyyy'), 1, 2)

1 row(s) inserted.

Statement 21

INSERT INTO T_EVENT VALUES(123, 222, TO_DATE('02/06/2017','mm/dd/yyyy'), 2, 3)

1 row(s) inserted.

Statement 22

INSERT INTO T_EVENT VALUES(123, 111, TO_DATE('04/03/2017','mm/dd/yyyy'), 2, 4)

1 row(s) inserted.

Statement 23

INSERT INTO T_EVENT VALUES(456, 333, TO_DATE('08/01/2016','mm/dd/yyyy'), 1, 5)

1 row(s) inserted.

Statement 24

INSERT INTO T_EVENT VALUES(456, 444, TO_DATE('01/18/2017','mm/dd/yyyy'), 1, 6)

1 row(s) inserted.

Statement 25

INSERT INTO T_EVENT VALUES(777, 111, TO_DATE('08/22/2016','mm/dd/yyyy'), 1, 7)

1 row(s) inserted.

Statement 26

INSERT INTO T_EVENT VALUES(777, 222, TO_DATE('12/07/2016','mm/dd/yyyy'), 1, 8)

1 row(s) inserted.

Statement 27

INSERT INTO T_EVENT VALUES(777, 111, TO_DATE('12/07/2016','mm/dd/yyyy'), 2, 9)

1 row(s) inserted.

Statement 28

INSERT INTO T_EVENT VALUES(777, 222, TO_DATE('12/14/2016','mm/dd/yyyy'), 2, 10)

1 row(s) inserted.

Statement 29

INSERT INTO T_EVENT VALUES(777, 333, TO_DATE('01/20/2017','mm/dd/yyyy'), 1, 11)

1 row(s) inserted.

Statement 30

INSERT INTO T_EVENT VALUES(777, 333, TO_DATE('02/06/2017','mm/dd/yyyy'), 2, 12)

1 row(s) inserted.

Statement 31

INSERT INTO T_EVENT VALUES(777, 111, TO_DATE('02/06/2017','mm/dd/yyyy'), 1, 13)

1 row(s) inserted.

Statement 32

INSERT INTO T_EVENT VALUES(777, 111, TO_DATE('03/10/2017','mm/dd/yyyy'), 2, 14)

1 row(s) inserted.

Statement 33

select * from t_event


EMP_ID LOCATION_ID EVENT_DATE EVENT_TYPE CREATION_TRAN_SERIAL_NUMBER
123 111 01-AUG-16 1 1
123 222 18-JAN-17 1 2
123 222 06-FEB-17 2 3
123 111 03-APR-17 2 4
456 333 01-AUG-16 1 5
456 444 18-JAN-17 1 6
777 111 22-AUG-16 1 7
777 222 07-DEC-16 1 8
777 111 07-DEC-16 2 9
777 222 14-DEC-16 2 10
777 333 20-JAN-17 1 11
777 333 06-FEB-17 2 12
777 111 06-FEB-17 1 13
777 111 10-MAR-17 2 14

14 rows selected.

EMP_ID	LOCATION_ID	EVENT_DATE	EVENT_TYPE	CREATION_TRAN_SERIAL_NUMBER
123	111	01-AUG-16	1	1
123	222	18-JAN-17	1	2
123	222	06-FEB-17	2	3
123	111	03-APR-17	2	4
456	333	01-AUG-16	1	5
456	444	18-JAN-17	1	6
777	111	22-AUG-16	1	7
777	222	07-DEC-16	1	8
777	111	07-DEC-16	2	9
777	222	14-DEC-16	2	10
777	333	20-JAN-17	1	11
777	333	06-FEB-17	2	12
777	111	06-FEB-17	1	13
777	111	10-MAR-17	2	14

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database