Sha256: 2e517fe6bca7fa0f22db7556d6809a6e0940c19a81ce483e221503824d239a7e
Contents?: true
Size: 921 Bytes
Versions: 11
Compression:
Stored size: 921 Bytes
Contents
DROP TABLE TEST1;
CREATE TABLE TEST1 (
ID CHAR(2),
C1 DECIMAL(12,2),
C2 CHAR(8),
C3 VARCHAR2(8),
C4 NVARCHAR2(8),
C5 DATE,
C6 TIMESTAMP,
C7 TIMESTAMP(3),
PRIMARY KEY(ID));
INSERT INTO TEST1 VALUES(
'10',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL);
INSERT INTO TEST1 VALUES(
'11',
-1234567890.12,
'ABCDEF',
'XYZ',
'ＡＢＣＤＥＦＧＨ',
TO_DATE('2015-06-04', 'YYYY-MM-DD'),
TO_TIMESTAMP('2015-06-05 23:45:06', 'YYYY-MM-DD HH24:MI:SS'),
TO_TIMESTAMP('2015-06-06 23:45:06.789', 'YYYY-MM-DD HH24:MI:SS.FF3'));
DROP TABLE TEST2;
CREATE TABLE TEST2 (
ID CHAR(2),
C1 BINARY_DOUBLE,
C2 BINARY_FLOAT,
PRIMARY KEY (ID));
INSERT INTO TEST2 VALUES('10', NULL, NULL);
INSERT INTO TEST2 VALUES('11', 123456789.012345, 123.4567);
INSERT INTO TEST2 VALUES('12', -123456789.012345, -123.4567);
EXIT;
Version data entries
11 entries across 11 versions & 1 rubygems