Datatypes in PL/SQL

Datatypes in PL/SQL

There are different datatypes in PL/SQL:

  1. Scalar Types: This basic data-type holds a single value, such as, number or string of characters.
  2. LOB Types: This data-type specifies the location of large objects, such as, text files, images, etc.
  3. Reference Types: This data-type is used to hold pointer values which generally stores the address of other program items.
  4. Composite Types: This type of data is a composition of individual data that can be manipulated/processed separately as well.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.