A datatype allows you to declare the data type of record variables fields, constants, functions return value, collection variables and collection types elements.

• Record Variable Declaration

• Constant Declaration

• Function Declaration and Definition

• Collection Variable Declaration

• CREATE FUNCTION Statement

• CREATE TYPE Statement

Topics

• Syntax

• Semantics

• Related Topics

Syntax

datatype ::=

Description of the illustration datatype.eps

(rowtype_attribute ::=, type_attribute ::=)

Semantics

datatype

collection_type

Name of a user-defined varray or nested table type (not the name of an associative array type).

object_type

Instance of a user-defined type.

record_type

Name of a user-defined type that was defined with the data type specifier RECORD.

ref_cursor_type

Name of a user-defined type that was defined with the data type specifier REF CURSOR.

scalar_datatype

Name of a scalar data type, including any qualifiers for size, precision, and character or byte semantics.

Related Topics

In other chapters:

• PL/SQL Data Types