Oracle PLSQL Types


Oracle PL/SQL Types

Oracle PL/SQL supports all the types previously shown in Table A-1, plus the following additional Oracle PL/SQL specific types shown in Table A-2.

Table A-2: Oracle PL/SQL Types

Type

Description

BOOLEAN

Boolean value ( TRUE , FALSE , or NULL ).

BINARY_INTEGER

Integer between “2 31 ( “2,147,483,648) and 2 31 (2,147,483,648).

NATURAL

Subtype of BINARY_INTEGER . A non-negative integer.

NATURALN

Subtype of BINARY_INTEGER . A non-negative integer (and cannot be NULL ).

POSITIVE

Subtype of BINARY_INTEGER . A positive integer.

POSITIVEN

Subtype of BINARY_INTEGER . A positive integer (and cannot be NULL ).

SIGNTYPE

Subtype of BINARY_INTEGER . An integer of “1, 0, or 1.

PLS_INTEGER

Integer between “2 31 ( “2,147,483,648) and 2 31 (2,147,483,648). Similar to BINARY_INTEGER , but computations involving PLS_INTEGER values are faster.

STRING

Same as VARCHAR2 .

RECORD

Composite of a group of other types. Similar to a structure in C.

REF CURSOR

Pointer to a set of rows.




Oracle Database 10g SQL
Oracle Database 10g SQL (Osborne ORACLE Press Series)
ISBN: 0072229810
EAN: 2147483647
Year: 2004
Pages: 217

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net