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_INTEGERDECDECIMAL
DOUBLE PRECISIONFLOATINT
INTEGERNATURALNATURALN
NUMBERNUMERICPLS_INTEGER
POSITIVEPOSITIVENREAL
SIGNTYPESMALLINTCHAR
CHARACTERLONGLONG RAW
NCHARNVARCHAR2RAW
ROWIDSTRINGUROWID
VARCHARVARCHAR2BOOLEAN
DATEINTERVAL DAY TO SECONDINTERVAL YEAR TO MONTH
TIMESTAMPTIMESTAMP WITH LOCAL TIME ZONETIMESTAMP WITH TIME ZONE