DROP TABLE TEST_LOGIN_MASTER
ORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
DROP TABLE TEST_LOGIN_REQUEST
ORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
DROP TABLE TEST_LOGIN_ACCESS
ORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
CREATE TABLE TEST_LOGIN_MASTER
( PK_TEST_LOGIN_MASTER NUMBER(10,0),
LOGIN_MASTER NUMBER(10,0),
COMPANY_DETAILS NUMBER(10,0),
FK_TEST_LOGIN_REQUEST VARCHAR2(20)
)
Table created.
INSERT INTO TEST_LOGIN_MASTER
SELECT 1,1015918, 1557, 'REQUEST 1' FROM DUAL UNION
SELECT 2,1015918, 1680, 'REQUEST 3' FROM DUAL UNION
SELECT 3,1015918, 13770, 'REQUEST 4' FROM DUAL UNION
SELECT 4,1015918, 13771, NULL FROM DUAL UNION
SELECT 5,1015918, 13906, NULL FROM DUAL
5 row(s) inserted.
CREATE TABLE TEST_LOGIN_REQUEST
( PK_TEST_LOGIN_REQUEST VARCHAR2(20),
STATUS VARCHAR2(2)
)
Table created.
INSERT INTO TEST_LOGIN_REQUEST
SELECT 'REQUEST 1', 'AC' FROM DUAL UNION
SELECT 'REQUEST 2', 'AC' FROM DUAL UNION
SELECT 'REQUEST 3', 'AC' FROM DUAL
3 row(s) inserted.
CREATE TABLE TEST_LOGIN_ACCESS
( LOGIN_MASTER NUMBER(10,0),
COMPANY_DETAILS NUMBER(10,0)
)
Table created.
INSERT INTO TEST_LOGIN_ACCESS
SELECT 1015918, 1557 FROM DUAL UNION
SELECT 1015918, 1680 FROM DUAL UNION
SELECT 1015918, 13770 FROM DUAL UNION
SELECT 1015918, 13771 FROM DUAL UNION
SELECT 1015918, 13906 FROM DUAL
5 row(s) inserted.
COMMIT
Statement processed.