DROP TABLE TAB_LOGIN_DETAILS ORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
DROP TABLE TAB_REQUEST ORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
DROP TABLE TAB_ACCESS ORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
CREATE TABLE TAB_LOGIN_DETAILS
( PK_TB_CCRS_LOGIN_DETAILS NUMBER(10,0),
FK_TB_LOGIN_MASTER NUMBER(10,0),
FK_TB_COMPANY_DETAILS NUMBER(10,0),
FK_TB_CCRS_PAT_REQUEST NUMBER(10,0),
REC_STATUS VARCHAR2(2 CHAR)
) Table created.
Insert into TAB_LOGIN_DETAILS (PK_TB_CCRS_LOGIN_DETAILS,FK_TB_LOGIN_MASTER,FK_TB_COMPANY_DETAILS,FK_TB_CCRS_PAT_REQUEST,REC_STATUS) values (34097,1022,1001,null,'AC')1 row(s) inserted.
Insert into TAB_LOGIN_DETAILS (PK_TB_CCRS_LOGIN_DETAILS,FK_TB_LOGIN_MASTER,FK_TB_COMPANY_DETAILS,FK_TB_CCRS_PAT_REQUEST,REC_STATUS) values (34117,1022,1001,null,'AC')1 row(s) inserted.
Insert into TAB_LOGIN_DETAILS (PK_TB_CCRS_LOGIN_DETAILS,FK_TB_LOGIN_MASTER,FK_TB_COMPANY_DETAILS,FK_TB_CCRS_PAT_REQUEST,REC_STATUS) values (33717,1022,1002,null,'AC')1 row(s) inserted.
Insert into TAB_LOGIN_DETAILS (PK_TB_CCRS_LOGIN_DETAILS,FK_TB_LOGIN_MASTER,FK_TB_COMPANY_DETAILS,FK_TB_CCRS_PAT_REQUEST,REC_STATUS) values (45558,1022,1003,null,'AC')1 row(s) inserted.
Insert into TAB_LOGIN_DETAILS (PK_TB_CCRS_LOGIN_DETAILS,FK_TB_LOGIN_MASTER,FK_TB_COMPANY_DETAILS,FK_TB_CCRS_PAT_REQUEST,REC_STATUS) values (45210,1022,1003,1111,'AC')1 row(s) inserted.
Insert into TAB_LOGIN_DETAILS (PK_TB_CCRS_LOGIN_DETAILS,FK_TB_LOGIN_MASTER,FK_TB_COMPANY_DETAILS,FK_TB_CCRS_PAT_REQUEST,REC_STATUS) values (45209,1022,1003,2222,'AC')1 row(s) inserted.
Insert into TAB_LOGIN_DETAILS (PK_TB_CCRS_LOGIN_DETAILS,FK_TB_LOGIN_MASTER,FK_TB_COMPANY_DETAILS,FK_TB_CCRS_PAT_REQUEST,REC_STATUS) values (44842,1022,1003,null,'AC')1 row(s) inserted.
Insert into TAB_LOGIN_DETAILS (PK_TB_CCRS_LOGIN_DETAILS,FK_TB_LOGIN_MASTER,FK_TB_COMPANY_DETAILS,FK_TB_CCRS_PAT_REQUEST,REC_STATUS) values (45002,1022,1003,3333,'AC')1 row(s) inserted.
CREATE TABLE TAB_REQUEST
( PK_TB_CCRS_PAT_REQUEST NUMBER(10,0),
FK_TB_LOGIN_MASTER NUMBER(10,0),
FK_TB_COMPANY_DETAILS NUMBER(10,0),
REC_STATUS VARCHAR2(2 CHAR)
) Table created.
Insert into TAB_REQUEST (PK_TB_CCRS_PAT_REQUEST,FK_TB_LOGIN_MASTER,FK_TB_COMPANY_DETAILS,REC_STATUS) values (1111,1022,1003,'AC')1 row(s) inserted.
Insert into TAB_REQUEST (PK_TB_CCRS_PAT_REQUEST,FK_TB_LOGIN_MASTER,FK_TB_COMPANY_DETAILS,REC_STATUS) values (2222,1022,1003,'DL')1 row(s) inserted.
Insert into TAB_REQUEST (PK_TB_CCRS_PAT_REQUEST,FK_TB_LOGIN_MASTER,FK_TB_COMPANY_DETAILS,REC_STATUS) values (3333,1022,1003,'DL')1 row(s) inserted.
CREATE TABLE TAB_ACCESS
( FK_TB_CCRS_LOGIN_DETAILS NUMBER(10,0),
TYPE NUMBER(1,0),
REC_STATUS VARCHAR2(2 CHAR)
) Table created.
Insert into TAB_ACCESS (FK_TB_CCRS_LOGIN_DETAILS,TYPE,REC_STATUS) values (33717,1,'DL')1 row(s) inserted.
Insert into TAB_ACCESS (FK_TB_CCRS_LOGIN_DETAILS,TYPE,REC_STATUS) values (33717,2,'DL')1 row(s) inserted.
Insert into TAB_ACCESS (FK_TB_CCRS_LOGIN_DETAILS,TYPE,REC_STATUS) values (34117,1,'AC')1 row(s) inserted.
Insert into TAB_ACCESS (FK_TB_CCRS_LOGIN_DETAILS,TYPE,REC_STATUS) values (34117,2,'DL')1 row(s) inserted.
Insert into TAB_ACCESS (FK_TB_CCRS_LOGIN_DETAILS,TYPE,REC_STATUS) values (34117,3,'DL')1 row(s) inserted.
COMMITStatement processed.