次に、JSON_TABLE出力でサポートされているデータ型のリストを示します。角括弧は、型指定におけるオプションの値を示します。
CHAR(n) |
VARCHAR(n) |
BYTE(n) |
VARBYTE(n) |
BYTEINT |
SMALLINT |
INTEGER |
FLOAT/REAL |
DECIMAL/NUMERIC [(n,[m])] |
NUMBER |
DATE |
TIME [(fractional_seconds_precision)] |
TIME [(fractional_seconds_precision)] WITH TIME ZONE |
TIMESTAMP [(fractional_seconds_precision)] |
TIMESTAMP [(fractional_seconds_precision)] WITH TIME ZONE |
INTERVAL YEAR [(precision)] |
INTERVAL YEAR [(precision)] TO MONTH |
INTERVAL MONTH [(precision)] |
INTERVAL DAY[(precision)] |
INTERVAL DAY[(precision)] TO HOUR |
INTERVAL DAY[(precision)] TO MINUTE |
INTERVAL DAY [(precision)] TO SECOND |
INTERVAL HOUR [(precision)] |
INTERVAL HOUR [(precision)] TO MINUTE |
INTERVAL HOUR [(precision)] TO SECOND |
INTERVAL MINUTE [(precision)] |
INTERVAL MINUTE [(precision)] TO SECOND |
INTERVAL SECOND [(fractional_seconds_precision)] |