Introducing the Main Data type Groups : Introduction « PL SQL Data Types « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Data Types
  3. Introduction

There are four main groups:

  1. Scalar datatypes represent single values that can't be divided into parts.
  2. Composite datatypes include internal components that can be manipulated independently.
  3. %ROWTYPE is an example of the PL/SQL RECORD datatype.
  4. References contain pointers to other program items.
  5. Large objects store or point to large amounts of textual or binary information, such as images, movies, or books.

Scalar datatypes are divided into families:

  1. Numeric datatypes.
  2. Character datatypes.
  3. Date/time datatypes.
  4. Boolean datatypes.








21.1.Introduction
21.1.1.Block Structure
21.1.2.Your First PL/SQL Block
21.1.3.The slash character (/) at the end of the example executes the PL/SQL.
21.1.4.You can declare the whole string to be enclosed in quotes by using the construct q'!text!'
21.1.5.All identifiers within the same scope must be unique.
21.1.6.Building Expressions with Operators
21.1.7.PL/SQL datatypes
21.1.8.Variable Naming Rules
21.1.9.Introducing the Main Data type Groups