CREATE TABLE PROJECTSM
(PROJECT_NUMBER VARCHAR2(30),
START_DATE DATE,
END_DATE DATE)
Table created.
INSERT INTO PROJECTSM VALUES('P1000','01-JAN-2023','31-DEC-2023')
1 row(s) inserted.
INSERT INTO PROJECTSM VALUES('P1001','01-JAN-2023','31-DEC-2023')
1 row(s) inserted.
CREATE TABLE EMPPROJECTS
(EMPNO VARCHAR2(30),
PROJECT_NUMBER VARCHAR2(100),
PROJECT_IN_DATE DATE,
PROJECT_OUT_DATE DATE)
ORA-00955: name is already used by an existing objectMore Details: https://docs.oracle.com/error-help/db/ora-00955
INSERT INTO EMPPROJECTS VALUES ('001','P1000','15-JAN-2023','06-JUN-2023')
1 row(s) inserted.
INSERT INTO EMPPROJECTS VALUES ('001','P1000','30-JAN-2023','17-JUL-2023')
1 row(s) inserted.
COMMIT
Statement processed.
SELECT * FROM EMPPROJECTS
EMPNO | PROJECT_NUMBER | PROJECT_IN_DATE | PROJECT_OUT_DATE | 001 | P1000 | 15-JAN-23 | 06-JUN-23 | 001 | P1000 | 30-JAN-23 | 17-JUL-23 | 001 | P1000 | 15-JAN-23 | 06-JUN-23 | 001 | P1000 | 30-JAN-23 | 17-JUL-23 |
---|
COMMIT
Statement processed.
INSERT INTO PROJECTSM VALUES('P1001','01-JAN-2023','31-DEC-2023')
1 row(s) inserted.
COMMIT
Statement processed.
SELECT * FROM PROJECTM
ORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
SELECT * FROM PROJECTM
ORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
SELECT * FROM PROJECTSM
PROJECT_NUMBER | START_DATE | END_DATE | P1000 | 01-JAN-23 | 31-DEC-23 | P1001 | 01-JAN-23 | 31-DEC-23 | P1000 | 01-JAN-23 | 31-DEC-23 | P1001 | 01-JAN-23 | 31-DEC-23 |
---|
DROP TABLE PROJECTSM
Table dropped.
DROP TABLE EMPPROJECTS
Table dropped.
CREATE TABLE PROJECTSM
(PROJECT_NUMBER VARCHAR2(30),
START_DATE DATE,
END_DATE DATE)
Table created.
INSERT INTO PROJECTSM VALUES('P1000','01-JAN-2023','31-DEC-2023')
1 row(s) inserted.
INSERT INTO PROJECTSM VALUES('P1001','01-JAN-2023','31-DEC-2023')
1 row(s) inserted.
COMMIT
Statement processed.
CREATE TABLE EMPPROJECTS
(EMPNO VARCHAR2(30),
PROJECT_NUMBER VARCHAR2(100),
PROJECT_IN_DATE DATE,
PROJECT_OUT_DATE DATE)
Table created.
INSERT INTO EMPPROJECTS VALUES ('001','P1000','15-JAN-2023','06-JUN-2023')
1 row(s) inserted.
INSERT INTO EMPPROJECTS VALUES ('001','P1000','30-JAN-2023','17-JUL-2023')
1 row(s) inserted.
COMMIT
Statement processed.
SELECT * FROM EMPPROJECTS
EMPNO | PROJECT_NUMBER | PROJECT_IN_DATE | PROJECT_OUT_DATE | 001 | P1000 | 15-JAN-23 | 06-JUN-23 | 001 | P1000 | 30-JAN-23 | 17-JUL-23 |
---|
SELECT * FROM PROJECTSM
PROJECT_NUMBER | START_DATE | END_DATE | P1000 | 01-JAN-23 | 31-DEC-23 | P1001 | 01-JAN-23 | 31-DEC-23 |
---|
SELECT * FROM EMPPROJECTS
EMPNO | PROJECT_NUMBER | PROJECT_IN_DATE | PROJECT_OUT_DATE | 001 | P1000 | 15-JAN-23 | 06-JUN-23 | 001 | P1000 | 30-JAN-23 | 17-JUL-23 |
---|
SELECT * FROM PROJECTSM
PROJECT_NUMBER | START_DATE | END_DATE | P1000 | 01-JAN-23 | 31-DEC-23 | P1001 | 01-JAN-23 | 31-DEC-23 |
---|
DROP TABLE PROJECTSM
Table dropped.
DROP TABLE EMPPROJECTS
Table dropped.
CREATE TABLE PROJECTSM
(PROJECT_NUMBER VARCHAR2(30),
START_DATE DATE,
END_DATE DATE)
Table created.
INSERT INTO PROJECTSM VALUES('P1000','01-JAN-2023','31-DEC-2023')
1 row(s) inserted.
INSERT INTO PROJECTSM VALUES('P1001','01-JAN-2023','31-DEC-2023')
1 row(s) inserted.
COMMIT
Statement processed.
CREATE TABLE EMPPROJECTS
(EMPNO VARCHAR2(30),
PROJECT_NUMBER VARCHAR2(100),
PROJECT_IN_DATE DATE,
PROJECT_OUT_DATE DATE)
Table created.
INSERT INTO EMPPROJECTS VALUES ('001','P1000','15-JAN-2023','06-JUN-2023')
1 row(s) inserted.
INSERT INTO EMPPROJECTS VALUES ('001','P1000','30-JAN-2023','17-JUL-2023')
1 row(s) inserted.
COMMIT
Statement processed.
SELECT * FROM EMPPROJECTS
EMPNO | PROJECT_NUMBER | PROJECT_IN_DATE | PROJECT_OUT_DATE | 001 | P1000 | 15-JAN-23 | 06-JUN-23 | 001 | P1000 | 30-JAN-23 | 17-JUL-23 |
---|
SELECT * FROM PROJECTSM
PROJECT_NUMBER | START_DATE | END_DATE | P1000 | 01-JAN-23 | 31-DEC-23 | P1001 | 01-JAN-23 | 31-DEC-23 |
---|
DROP TABLE PROJECTSM
Table dropped.
DROP TABLE EMPPROJECTS
Table dropped.
CREATE TABLE PROJECTSM
(PROJECT_NUMBER VARCHAR2(30),
START_DATE DATE,
END_DATE DATE)
Table created.
INSERT INTO PROJECTSM VALUES('P1000','01-JAN-2023','31-DEC-2023')
1 row(s) inserted.
INSERT INTO PROJECTSM VALUES('P1001','01-JAN-2023','31-DEC-2023')
1 row(s) inserted.
COMMIT
Statement processed.
CREATE TABLE EMPPROJECTS
(EMPNO VARCHAR2(30),
PROJECT_NUMBER VARCHAR2(100),
PROJECT_IN_DATE DATE,
PROJECT_OUT_DATE DATE)
Table created.
INSERT INTO EMPPROJECTS VALUES ('001','P1000','15-JAN-2023','06-JUN-2023')
1 row(s) inserted.
INSERT INTO EMPPROJECTS VALUES ('001','P1000','30-JUN-2023','17-JUL-2023')
1 row(s) inserted.
COMMIT
Statement processed.
SELECT * FROM EMPPROJECTS
EMPNO | PROJECT_NUMBER | PROJECT_IN_DATE | PROJECT_OUT_DATE | 001 | P1000 | 15-JAN-23 | 06-JUN-23 | 001 | P1000 | 30-JUN-23 | 17-JUL-23 |
---|
SELECT * FROM PROJECTSM
PROJECT_NUMBER | START_DATE | END_DATE | P1000 | 01-JAN-23 | 31-DEC-23 | P1001 | 01-JAN-23 | 31-DEC-23 |
---|
SELECT * FROM EMPPROJECTS
EMPNO | PROJECT_NUMBER | PROJECT_IN_DATE | PROJECT_OUT_DATE | 001 | P1000 | 15-JAN-23 | 06-JUN-23 | 001 | P1000 | 30-JUN-23 | 17-JUL-23 |
---|