-- Types test
ALTER system archive LOG CURRENT;
CREATE TABLE tester_src.typestest
(
    f1     VARCHAR2(32),
    f2     nvarchar2(32),
    f3     VARCHAR(32),
    f4     CHAR(32),
    f5     nchar(32),
    f6     NUMBER,
    f7     LONG,
    f8     DATE,
    f9     TIMESTAMP,
    f10    TIMESTAMP WITH TIME ZONE,
    f11    RAW(32),
    f12    clob,
    f13    nclob,
    f14    blob,
    f15    xmltype,
    f16    binary_double,
    f17    FLOAT(8),
    f18    binary_float
);
ALTER system archive LOG CURRENT;
INSERT INTO tester_src.typestest
     VALUES (
                '12345678901234567890123456789012',
                '12345678901234567890123456789012',
                '12345678901234567890123456789012',
                '12345678901234567890123456789012',
                '12345678901234567890123456789012',
                DBMS_RANDOM.VALUE(),
                DBMS_RANDOM.string('a', 4000),
                CURRENT_DATE,
                CURRENT_TIMESTAMP,
                CURRENT_TIMESTAMP,
                '1122334455667788990011223344556677889900112233445566778899001122',
                DBMS_RANDOM.string('a', 4000),
                DBMS_RANDOM.string('a', 4000),
                '112233445566778899001122334455667788990011223344556677889900112233445566778899001122334455667788990011223344556677889900112233445566778899001122334455667788990011223344556677889900112233445566778899001122334455667788990011223344556677889900',
                XMLType(
                    '<Warehouse whNo="100"><Building>Owned</Building></Warehouse>'),
                to_binary_double(1.00002),
                0.123,
                to_binary_float(1.2));
ALTER system archive LOG CURRENT;
ALTER TABLE tester_src.typestest add (a1 VARCHAR2(32));
ALTER TABLE tester_src.typestest add (a2 nvarchar2(32));
ALTER TABLE tester_src.typestest add (a3 VARCHAR(32));
ALTER TABLE tester_src.typestest add (a4 CHAR(32));
ALTER TABLE tester_src.typestest add (a5 nchar(32));
ALTER TABLE tester_src.typestest add (a6 NUMBER);
ALTER TABLE tester_src.typestest add (a8 DATE);
ALTER TABLE tester_src.typestest add (a9 TIMESTAMP);
ALTER TABLE tester_src.typestest add (a10 TIMESTAMP WITH TIME ZONE);
ALTER TABLE tester_src.typestest add (a11 RAW(32));
ALTER TABLE tester_src.typestest add (a12 clob);
ALTER TABLE tester_src.typestest add (a13 nclob);
ALTER TABLE tester_src.typestest add (a14 blob);
ALTER TABLE tester_src.typestest add (a15 xmltype);
ALTER TABLE tester_src.typestest add (a16 binary_double);
ALTER TABLE tester_src.typestest add (a17 FLOAT(8));
ALTER TABLE tester_src.typestest add (a18 binary_float);
ALTER system archive LOG CURRENT;
INSERT INTO tester_src.typestest
     VALUES (
                '12345678901234567890123456789012',
                '12345678901234567890123456789012',
                '12345678901234567890123456789012',
                '12345678901234567890123456789012',
                '12345678901234567890123456789012',
                DBMS_RANDOM.VALUE(),
                DBMS_RANDOM.string('a', 4000),
                CURRENT_DATE,
                CURRENT_TIMESTAMP,
                CURRENT_TIMESTAMP,
                '1122334455667788990011223344556677889900112233445566778899001122',
                DBMS_RANDOM.string('a', 4000),
                DBMS_RANDOM.string('a', 4000),
                '112233445566778899001122334455667788990011223344556677889900112233445566778899001122334455667788990011223344556677889900112233445566778899001122334455667788990011223344556677889900112233445566778899001122334455667788990011223344556677889900',
                XMLType(
                    '<Warehouse whNo="100"><Building>Owned</Building></Warehouse>'),
                to_binary_double(1.00002),
                0.123,
                to_binary_float(1.2),
                '12345678901234567890123456789012',
                '12345678901234567890123456789012',
                '12345678901234567890123456789012',
                '12345678901234567890123456789012',
                '12345678901234567890123456789012',
                DBMS_RANDOM.VALUE(),
                CURRENT_DATE,
                CURRENT_TIMESTAMP,
                CURRENT_TIMESTAMP,
                '1122334455667788990011223344556677889900112233445566778899001122',
                DBMS_RANDOM.string('a', 4000),
                DBMS_RANDOM.string('a', 4000),
                '112233445566778899001122334455667788990011223344556677889900112233445566778899001122334455667788990011223344556677889900112233445566778899001122334455667788990011223344556677889900112233445566778899001122334455667788990011223344556677889900',
                XMLType(
                    '<Warehouse whNo="100"><Building>Owned</Building></Warehouse>'),
                to_binary_double(1.00002),
                0.123,
                to_binary_float(1.2));
ALTER system archive LOG CURRENT;
DROP TABLE tester_src.typestest;
ALTER system archive LOG CURRENT;