CREATE TABLE CREDIT ( DATA DATE, USER_ID VARCHAR2(200 BYTE), TRANSACTION NUMBER(2) ) Insert into CREDIT (DATA, USER_ID, TRANSACTION) Values (TO_DATE('03/19/2007 00:00:02', 'MM/DD/YYYY HH24:MI:SS'), 'FBAKO', 3); Insert into CREDIT (DATA, USER_ID, TRANSACTION) Values (TO_DATE('03/20/2007 00:00:59', 'MM/DD/YYYY HH24:MI:SS'), 'FBAKO', 5); Insert into CREDIT (DATA, USER_ID, TRANSACTION) Values (TO_DATE('03/20/2007 00:00:01', 'MM/DD/YYYY HH24:MI:SS'), 'FBAKO', 5); Insert into CREDIT (DATA, USER_ID, TRANSACTION) Values (TO_DATE('03/21/2007 00:00:59', 'MM/DD/YYYY HH24:MI:SS'), 'BEKI', 5); Insert into CREDIT (DATA, USER_ID, TRANSACTION) Values (TO_DATE('03/25/2007 00:00:59', 'MM/DD/YYYY HH24:MI:SS'), 'BEKI', 10); Insert into CREDIT (DATA, USER_ID, TRANSACTION) Values (TO_DATE('03/30/2007 00:00:59', 'MM/DD/YYYY HH24:MI:SS'), 'BEKI', 5); CREATE TABLE POS_STAF_HIS ( TRANSFER_DATE DATE, USER_ID VARCHAR2(200 BYTE), POS_ID VARCHAR2(200 BYTE) ) Insert into POS_STAF_HIS (TRANSFER_DATE, USER_ID, POS_ID) Values (TO_DATE('03/19/2007 01:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'FBAKO', 'PZ 01'); Insert into POS_STAF_HIS (TRANSFER_DATE, USER_ID, POS_ID) Values (TO_DATE('03/20/2007 01:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'FBAKO', 'PZ 02'); Insert into POS_STAF_HIS (TRANSFER_DATE, USER_ID, POS_ID) Values (TO_DATE('03/21/2007 00:00:59', 'MM/DD/YYYY HH24:MI:SS'), 'BEKI', 'PR 1'); Insert into POS_STAF_HIS (TRANSFER_DATE, USER_ID, POS_ID) Values (TO_DATE('03/26/2007 00:00:59', 'MM/DD/YYYY HH24:MI:SS'), 'BEKI', 'PR 2'); Insert into POS_STAF_HIS (TRANSFER_DATE, USER_ID, POS_ID) Values (TO_DATE('03/19/2007 01:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'BEKI', 'PR 03'); COMMIT;