Tuesday, 22 May 2012

What are the different datatypes that can be defined in a PL/SQL block? | PL SQL

  The following categories of datatypes are supported by PL/SQL:
1. Scalar — Holds a single value and does not contain any internal component. Some of its data types are given as follows:
 =>   CHAR
 =>   VARCHAR2
 =>   NUMBER
 =>   LONG
 =>   INT
 =>   INTEGER
 =>    BINARYINTEGER
 =>   DATE
 =>   BOOLEAN
 =>   SMALLINT
 =>   POSITIVE
 =>   POSITIVEN
2. Composite — Contains an internal component, which can be manipulated individually. It is also known as collections and includes the following data types:
=>    TABLE
=>    RECORD
=>    NESTED TABLE
=>    VARRAY
3. Reference — Holds values called pointers, which designate to other objects. It includes the following data types:
=>    REF CURSOR
=>    REF object_type
4. LOB — Holds values, which specify the location of large objects, such as images and video clips. It can store up to 4GB of unstructured data. It includes the following data types:
=>    BFILE
=>    BLOB
=>    CLOB
=>    NCLOB
 

No comments: