DROP TABLE TRX;
CREATE TABLE TRX (
    TRX_ID VARCHAR(50) NOT NULL,
    TRX_DESCRIPTION VARCHAR(250),
    LAST_UPDATE_TS DATE NOT NULL,
    TRX_TYPE VARCHAR(25)
);
INSERT INTO TRX VALUES ('ID_0', 'DESCRIPTION_0', TO_DATE('05.11.2006', 'DD.MM.YYYY'), 'TYPE_0');
INSERT INTO TRX VALUES ('ID_1', 'DESCRIPTION_1', TO_DATE('09.07.2007', 'DD.MM.YYYY'), 'TYPE_1');
INSERT INTO TRX VALUES ('ID_2', 'DESCRIPTION_2', TO_DATE('14.11.2007', 'DD.MM.YYYY'), 'TYPE_2');
INSERT INTO TRX VALUES ('ID_3', 'DESCRIPTION_3', TO_DATE('27.12.2007', 'DD.MM.YYYY'), 'TYPE_3');