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
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:
Post a Comment