RelationalDBDesign
RedhatLinuxSys Seomining
prev next prev next
Course navigation
Variable PL / SQL Data Types
PL/SQL datatypes
The correct values and their datatypes are:
  1. TRUE : SCALAR datatype
  2. RECORD : COMPOSITE datatype
  3. %ROWTYPE : REFERENCE datatype
  4. BLOB : LOB datatype
Every constant, variable, and parameter has a datatype (or type), which specifies a storage format, constraints, and valid range of values.
PL/SQL provides many predefined datatypes. For instance, you can choose from
  1. integer,
  2. floating point,
  3. character,
  4. BOOLEAN,
  5. date,
  6. collection,
  7. reference, and
  8. large object (LOB) types.
PL/SQL also lets you define your own subtypes. This chapter covers the basic types used frequently in PL/SQL programs. Later chapters cover the more specialized types.
Course navigation