SQL data types for Oracle/PLSQL

PLSQL datatypes

In this article, we will understand briefly PLSQL datatypes. Each value in PL/SQL such as constant, variable, or parameter has a data type that defines their storage and calculation behavior. PL/SQL has basically two types of data types e.g scalar and composite.

Types of sql data types

Scalar data types

In scalar data type are those data type that stores a single value. Scalar data type has further four data subtypes

  • Number
  • Boolean
  • Character
  • Datetime
Composite data types

Whereas composite data type stores multiple values. There are two data sub types of composite data types are available.

  • Record
  • Collection

In this article, we will be discussing only scalar data type

Oracle number data type

The numeric data … Continue Reading