1 2 3 4 5 6 7 8 9 10 11 12 13
| Insert into TEST_TABLE (TID,TIMESTAMP,AVAILABILTY) values ( 1 ,TO_DATE('29/08/2011 10:01','DD/MM/YYYY HH24:MI'), 'Y');
Insert into TEST_TABLE (TID,TIMESTAMP,AVAILABILTY) values ( 1 ,TO_DATE('29/08/2011 10:02','DD/MM/YYYY HH24:MI'), 'N');
Insert into TEST_TABLE (TID,TIMESTAMP,AVAILABILTY) values ( 1 ,TO_DATE('29/08/2011 10:04','DD/MM/YYYY HH24:MI'), 'Y');
Insert into TEST_TABLE (TID,TIMESTAMP,AVAILABILTY) values ( 1 ,TO_DATE('29/08/2011 10:06','DD/MM/YYYY HH24:MI'), 'N');
Insert into TEST_TABLE (TID,TIMESTAMP,AVAILABILTY) values ( 1 ,TO_DATE('29/08/2011 10:07','DD/MM/YYYY HH24:MI'), 'Y');
Insert into TEST_TABLE (TID,TIMESTAMP,AVAILABILTY) values ( 1 ,TO_DATE('29/08/2011 10:08','DD/MM/YYYY HH24:MI'), 'N');
Insert into TEST_TABLE (TID,TIMESTAMP,AVAILABILTY) values ( 2 ,TO_DATE('29/08/2011 10:01','DD/MM/YYYY HH24:MI'), 'N');
Insert into TEST_TABLE (TID,TIMESTAMP,AVAILABILTY) values ( 2 ,TO_DATE('29/08/2011 10:02','DD/MM/YYYY HH24:MI'), 'Y');
Insert into TEST_TABLE (TID,TIMESTAMP,AVAILABILTY) values ( 2 ,TO_DATE('29/08/2011 10:04','DD/MM/YYYY HH24:MI'), 'N');
Insert into TEST_TABLE (TID,TIMESTAMP,AVAILABILTY) values ( 2 ,TO_DATE('29/08/2011 10:06','DD/MM/YYYY HH24:MI'), 'Y');
Insert into TEST_TABLE (TID,TIMESTAMP,AVAILABILTY) values ( 2 ,TO_DATE('29/08/2011 10:07','DD/MM/YYYY HH24:MI'), 'N');
Insert into TEST_TABLE (TID,TIMESTAMP,AVAILABILTY) values ( 2 ,TO_DATE('29/08/2011 10:09','DD/MM/YYYY HH24:MI'), 'Y'); |
Partager