CREATE TABLE TEST_TBL(ID NUMBER,LOGTI FLOAT,ATTI FLOAT,SUB_TYPE VARCHAR2(20));
/



INSERT INTO TEST_TBL(ID,LOGTI,ATTI,SUB_TYPE) VALUES(1,345.466,577.86,'Y');
/
INSERT INTO TEST_TBL(ID,LOGTI,SUB_TYPE) VALUES(2,345.466,'Y');
/
INSERT INTO TEST_TBL(ID,LOGTI,SUB_TYPE) VALUES(3,678.789,'N');
/
INSERT INTO TEST_TBL(ID,LOGTI,SUB_TYPE) VALUES(4,98.9,'N');
/
INSERT INTO TEST_TBL(ID,LOGTI) VALUES(4,7899);
/



CREATE TABLE TEST_VALID_TBL(FIELD_NAME VARCHAR2(20),DATA_TYPE VARCHAR2(20),MANDATORY CHAR(1));
/


INSERT INTO TEST_VALID_TBL(FIELD_NAME,DATA_TYPE,MANDATORY) VALUES('ID','NUMBER','Y');
/
INSERT INTO TEST_VALID_TBL(FIELD_NAME,DATA_TYPE,MANDATORY) VALUES('LOGTI','FLOAT','Y');
/
INSERT INTO TEST_VALID_TBL(FIELD_NAME,DATA_TYPE,MANDATORY) VALUES('ATTI','FLOAT','Y');
/


CREATE TABLE VALID(ID NUMBER,LOGTI FLOAT,ATTI FLOAT,SUB_TYPE VARCHAR2(20));
/

CREATE TABLE INVALID(ID NUMBER,LOGTI FLOAT,ATTI FLOAT,SUB_TYPE VARCHAR2(20),REMAKS VARCHAR2(300));
/