Oracle PL/SQL Tutorial - PL/SQL Data Types






PL/SQL is the Procedural Language extension for SQL, it supports the same data types as SQL does for the database.

PL/SQL can handle any database data type and also has its own data types.

VARCHAR2: We'll work with character strings in PL/SQL using the data type VARCHAR2.

A PL/SQL VARCHAR2 can hold as many as 32,767 characters.

NUMBER: We'll work with numbers in PL/SQL using the data type NUMBER.

PL/SQL has additional numeric data types available. For example, you can use the type PLS_INTEGER, which has an integer range from -2147483648 to 2147483647.

DATE: We'll work with dates and times in PL/SQL using data type DATE.

PL/SQL has additional time-related data types.

PL/SQL also has a BOOLEAN data type that allows you to store the logical values FALSEor TRUE in a variable.