To design a programme using a language the minimum requirement is a variable and variable minimum requirement is data type.
It is a data type which can store one value at one point of time in form of one variable. The example of scalar data type are char, varchar, varchar2, number, date, Boolean.
Numeric - Numeric values, on which arithmetic operations are performed.
Character - Alphanumeric values that represent single characters or strings of characters.
Boolean - Logical values, on which logical operations are performed.
Datetime - Dates and times.
PL/SQL provides two types of data types :
- Scalar data type
- Composite data type
- Large Object (LOB)
It is a data type which can store one value at one point of time in form of one variable. The example of scalar data type are char, varchar, varchar2, number, date, Boolean.
Numeric - Numeric values, on which arithmetic operations are performed.
Character - Alphanumeric values that represent single characters or strings of characters.
Boolean - Logical values, on which logical operations are performed.
Datetime - Dates and times.
