PL/SQL Data Types

PL/SQL Data Types

The Oracle PL/SQL Data Types are: Scalar Types (number, character, date, boolean), Composite Types (Collections and Records), Reference Types (Cursor Variables), LOB Types (BFILE, BLOB, CLOB, NCLOB).

PL/SQL Number Types

BINARY_DOUBLE, BINARY_FLOAT, BINARY_INTEGER, DEC, DECIMAL, DOUBLE PRECISION, FLOAT, INT, INTEGER, NATURAL, NATURALN, NUMBER, NUMERIC, PLS_INTEGER, POSITIVE, POSITIVEN, REAL, SIGNTYPE, SMALLINT

PL/SQL Character and String Types

CHAR, CHARACTER, LONG, LONG RAW, NCHAR, NVARCHAR2, RAW, ROWID, STRING, UROWID, VARCHAR, VARCHAR2

PL/SQL Date, Time and Interval Types

DATE, TIMESTAMP, TIMESTAMP WITH TIMEZONE, TIMESTAMP WITH LOCAL TIMEZONE, INTERVAL YEAR TO MONTH, INTERVAL DAY TO SECOND

PL/SQL Boolean Types

BOOLEAN

Table with datatypes

BINARY_INTEGER DEC DECIMAL
DOUBLE PRECISION FLOAT INT
INTEGER NATURAL NATURALN
NUMBER NUMERIC PLS_INTEGER
POSITIVE POSITIVEN REAL
SIGNTYPE SMALLINT CHAR
CHARACTER LONG LONG RAW
NCHAR NVARCHAR2 RAW
ROWID STRING UROWID
VARCHAR VARCHAR2 BOOLEAN
DATE INTERVAL DAY TO SECOND INTERVAL YEAR TO MONTH
TIMESTAMP TIMESTAMP WITH LOCAL TIME ZONE TIMESTAMP WITH TIME ZONE