Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE DataTypes (
db_INTEGER INTEGER,
db_NUMBER NUMBER(4,0),
db_RAW RAW(200),
db_DATE DATE,
db_TIMESTAMP TIMESTAMP,
db_TIMESTAMP_WITH_LOCAL_TIME_ZONE TIMESTAMP WITH LOCAL TIME ZONE,
db_CHAR CHAR(400),
db_ROWID ROWID,
db_UROWID UROWID,
db_FLOAT FLOAT(10),
db_NCHAR NCHAR(400),
db_NVARCHAR2 NVARCHAR2(400),
db_VARCHAR2 VARCHAR2(400),
db_BINARY_FLOAT BINARY_FLOAT,
db_BINARY_DOUBLE BINARY_DOUBLE,
db_TIMESTAMP_WITH_TIME_ZONE TIMESTAMP WITH TIME ZONE,
db_INTERVAL_YEAR_TO_MONTH INTERVAL YEAR(3) TO MONTH,
db_INTERVAL_DAY_TO_SECOND INTERVAL DAY TO SECOND,
db_LONG LONG,
db_BLOB BLOB,
db_CLOB CLOB,
db_BFILE BFILE,
db_BOOLEAN CHAR(1),
CONSTRAINT PK PRIMARY KEY (db_INTEGER)
);
INSERT INTO DataTypes (
db_INTEGER,
db_NUMBER,
db_RAW,
db_DATE,
db_TIMESTAMP,
db_TIMESTAMP_WITH_LOCAL_TIME_ZONE,
db_CHAR,
db_ROWID,
db_UROWID,
db_FLOAT,
db_NCHAR,
db_NVARCHAR2,
db_VARCHAR2,
db_BINARY_FLOAT,
db_BINARY_DOUBLE,
db_TIMESTAMP_WITH_TIME_ZONE,
db_INTERVAL_YEAR_TO_MONTH,
db_INTERVAL_DAY_TO_SECOND,
db_LONG,
db_BLOB,
db_CLOB,
db_BFILE,
db_BOOLEAN
) VALUES (
1,
1234,
'48656C6C6F',
DATE '1980-12-17',
TIMESTAMP '1995-06-02 04:29:11.002',
TIMESTAMP '1995-06-02 04:29:11.002 UTC',
'Hello World! ',
'AAAGq9AAEAAAA0bAAA',
'AAAGq9AAEAAAA0bAAA',
123.45,
N'Hello World! ',
N'Hello World! ',
'Hello World! ',
123.456,
123.456789,
TIMESTAMP '1995-06-02 04:29:11.002 UTC',
INTERVAL '-123-3' YEAR(3) TO MONTH,
INTERVAL '-5 3:55' DAY TO MINUTE,
'123qwerty456',
UTL_RAW.CAST_TO_RAW('bGVhc3VyZS4='),
'Hello World! ',
BFILENAME('C:\Download', 'sample.txt'),
'Y'
);
1 rows affected