Posts

PL/SQL Datatypes

Image
What are PL/SQL Datatypes? A data type is associated with the specific storage format and range constraints. In Oracle, each value or constant is assigned with a data type. Basically, it defines how the data is stored, handled and treated by Oracle during the data storage and processing. The main difference between PL/SQL and  SQL  data types is, SQL data type are limited to table column while the PL/SQL data types are used in the PL/SQL blocks. More on this later in the tutorial. Following is the diagram of different Data Types in PL/SQL Here, you will learn- CHARACTER Data Type NUMBER Data Type BOOLEAN Data Type DATE Data Type LOB Data Type CHARACTER Data Type: This data type basically stores alphanumeric characters in string format. The literal values should always be enclosed in single quotes while assigning them to CHARACTER data type. This character data type is further classified as follows: CHAR Data type (fixed string size) VARCHAR2 Data type (variable string size) VARCHAR Dat