Enlist the data types that can be used in PL/SQL?


Posted On: Feb 22, 2018


Each constant, value and parameter has a data type that tells us the type of data used and their associated operations in the program. The following are four data types available in PL/SQL:

  1. Scalar data type-these are single-valued data types with no internal components. They are further classified into four categories-
  2. CHAR– these data types hold the fixed-length character strings. Its value ranges from 1 to 32,767 characters.
  3. VARCHAR2– these data types store variable-length character strings ranging from 1 to 32,767 characters.
  4. BOOLEAN– it is a data type with two values, true or false, intended to represent the truth values of logic and Boolean algebra.
  5. DATE– it is a data type for storing date and time information.
  6. LONG– it is an Oracle data type for storing character data of variable length.
  1. Composite data type- it is a combination of other data types and internal components that can be easily altered and manipulated. These include record, table and array.
  2. Reference data type- it is a data type that holds pointers to other data items. Ref Cursor is an example.
  3. Large object data type- These data types hold locators that defines the location of large objects stored out of the line. These are stored separately from other data items.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    PL/SQL Interview Questions

    What is PL/SQL?

    PL/SQL stands for Procedural Language extension of Structured Query Language (SQL). It is a block-structured language ha..

    PL/SQL Interview Questions

    Differentiate between PL/SQL and SQL?

    PL/SQL is Oracle’s Procedural Language SQL which allows you to write full programs to execute options like insert/ sel..

    PL/SQL Interview Questions

    State few characteristics of PL/SQL?

    Some of the characteristics of PL/SQL are furnished below: PL/SQL is completely portable as code can be executed on any ..