DROP TABLE SUBJECTS;
CREATE TABLE SUBJECTS
   (	SUBJECT_ID NUMBER NOT NULL,
	SUBJECT_CODE VARCHAR2(20 CHAR) NOT NULL,
	WHO_WRITE NUMBER(8,0) NOT NULL,
	DATE_OF_CHANGE TIMESTAMP (6) NOT NULL,
	REASON_TO_DELETE NUMBER(3,0)
   );
/* INSERTING into SUBJECTS */
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (144866,'11YVC',60413,to_timestamp('30.08.07 19:49:50,668837000','DD.MM.RR HH24:MI:SS,FF'),1);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (7875,'2041052',20524,to_timestamp('30.08.07 19:49:50,671085000','DD.MM.RR HH24:MI:SS,FF'),1);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (144766,'15RMBM',-2,to_timestamp('30.08.07 19:49:50,672850000','DD.MM.RR HH24:MI:SS,FF'),1);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (144915,'17YPSL',60885,to_timestamp('30.08.07 19:49:50,674645000','DD.MM.RR HH24:MI:SS,FF'),1);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (144916,'17YPS2',60885,to_timestamp('30.08.07 19:49:50,676416000','DD.MM.RR HH24:MI:SS,FF'),1);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (144917,'17YRD',60885,to_timestamp('30.08.07 19:49:50,678136000','DD.MM.RR HH24:MI:SS,FF'),1);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (18725,'36TAL',30841,to_timestamp('30.08.07 19:49:50,679975000','DD.MM.RR HH24:MI:SS,FF'),1);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (19076,'33ZSL1',32333,to_timestamp('30.08.07 19:49:50,681734000','DD.MM.RR HH24:MI:SS,FF'),1);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (19082,'37LT2',30841,to_timestamp('30.08.07 19:49:50,683443000','DD.MM.RR HH24:MI:SS,FF'),1);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (18714,'X04MF',30871,to_timestamp('30.08.07 19:49:50,685194000','DD.MM.RR HH24:MI:SS,FF'),1);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (19081,'X04CAE',30871,to_timestamp('30.08.07 19:49:50,686891000','DD.MM.RR HH24:MI:SS,FF'),1);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145239,'101XM11',10486,to_timestamp('30.08.07 19:49:50,699135000','DD.MM.RR HH24:MI:SS,FF'),3);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145240,'102XFY1',13655,to_timestamp('30.08.07 19:49:50,700898000','DD.MM.RR HH24:MI:SS,FF'),3);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145241,'102XFYS',13655,to_timestamp('30.08.07 19:49:50,702654000','DD.MM.RR HH24:MI:SS,FF'),3);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (144083,'124BUS2',14685,to_timestamp('30.08.07 19:49:50,704363000','DD.MM.RR HH24:MI:SS,FF'),3);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145133,'124KP4A',14302,to_timestamp('30.08.07 19:49:50,707821000','DD.MM.RR HH24:MI:SS,FF'),3);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145174,'102XMFM',13655,to_timestamp('30.08.07 19:49:50,711267000','DD.MM.RR HH24:MI:SS,FF'),3);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145182,'104XDF1',-2,to_timestamp('30.08.07 19:49:50,719122000','DD.MM.RR HH24:MI:SS,FF'),3);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145181,'104XDC1',14685,to_timestamp('30.08.07 19:49:50,717518000','DD.MM.RR HH24:MI:SS,FF'),3);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145180,'104XASP',-2,to_timestamp('30.08.07 19:49:50,715937000','DD.MM.RR HH24:MI:SS,FF'),3);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145179,'104XC12',10573,to_timestamp('30.08.07 19:49:50,714402000','DD.MM.RR HH24:MI:SS,FF'),3);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145178,'104XC11',10837,to_timestamp('30.08.07 19:49:50,712812000','DD.MM.RR HH24:MI:SS,FF'),3);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145149,'102FY3',13655,to_timestamp('30.08.07 19:49:50,709579000','DD.MM.RR HH24:MI:SS,FF'),3);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (144084,'125BEE1',14685,to_timestamp('30.08.07 19:49:50,706130000','DD.MM.RR HH24:MI:SS,FF'),3);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145104,'15QVP',60885,to_timestamp('30.08.07 19:49:50,688684000','DD.MM.RR HH24:MI:SS,FF'),4);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (19113,'XE37BPJ',30871,to_timestamp('30.08.07 19:49:50,690447000','DD.MM.RR HH24:MI:SS,FF'),4);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145175,'103XTV1',10837,to_timestamp('30.08.07 19:49:50,692179000','DD.MM.RR HH24:MI:SS,FF'),4);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145176,'103XZVK',10837,to_timestamp('30.08.07 19:49:50,693877000','DD.MM.RR HH24:MI:SS,FF'),4);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145237,'154LSS',12930,to_timestamp('30.08.07 19:49:50,695646000','DD.MM.RR HH24:MI:SS,FF'),4);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145164,'101MGT1',10486,to_timestamp('30.08.07 19:49:50,697413000','DD.MM.RR HH24:MI:SS,FF'),4);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145193,'105XFIT',14572,to_timestamp('30.08.07 19:49:50,720653000','DD.MM.RR HH24:MI:SS,FF'),null);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145194,'105XSOP',14572,to_timestamp('30.08.07 19:49:50,722282000','DD.MM.RR HH24:MI:SS,FF'),null);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145195,'124XCN1',14302,to_timestamp('30.08.07 19:49:50,723861000','DD.MM.RR HH24:MI:SS,FF'),null);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145242,'129XAK3',14727,to_timestamp('30.08.07 19:49:50,725412000','DD.MM.RR HH24:MI:SS,FF'),null);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (144085,'132STA',14685,to_timestamp('30.08.07 19:49:50,726996000','DD.MM.RR HH24:MI:SS,FF'),null);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (144087,'134STS2',-2,to_timestamp('30.08.07 19:49:50,728514000','DD.MM.RR HH24:MI:SS,FF'),null);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (144088,'135FOU1',14685,to_timestamp('30.08.07 19:49:50,730121000','DD.MM.RR HH24:MI:SS,FF'),null);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145042,'133BEKV',14376,to_timestamp('30.08.07 19:49:50,731635000','DD.MM.RR HH24:MI:SS,FF'),null);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145043,'134DKO',10910,to_timestamp('30.08.07 19:49:50,733220000','DD.MM.RR HH24:MI:SS,FF'),null);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145044,'141HYKV',11453,to_timestamp('30.08.07 19:49:50,734814000','DD.MM.RR HH24:MI:SS,FF'),null);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145045,'141HY2V',10837,to_timestamp('30.08.07 19:49:50,736330000','DD.MM.RR HH24:MI:SS,FF'),null);
Insert into SUBJECTS (SUBJECT_ID,SUBJECT_CODE,WHO_WRITE,DATE_OF_CHANGE,REASON_TO_DELETE) values (145053,'135ZSV',10837,to_timestamp('30.08.07 19:49:50,737913000','DD.MM.RR HH24:MI:SS,FF'),null);
COMMIT;