20. E PL/SQL预定义类型

本附录按数据类型族对包STANDARD预定义的数据类型和子类型进行分组。

CHAR 数据类型系列

SYS.DBMS_ID AS VARCHAR2(128);
SYS.DBMS_QUOTED_ID AS VARCHAR2(130);
SYS.DBMS_ID_30 AS VARCHAR2(30);
SYS.DBMS_QUOTED_ID_30 AS VARCHAR2(32);
SYS.STRING AS VARCHAR2;

DATE 数据类型系列

SYS.TIME_UNCONSTRAINED AS TIME(6);
SYS.TIME_TZ_UNCONSTRAINED AS TIME(6) WITH TIME ZONE;
SYS.TIMESTAMP_UNCONSTRAINED AS TIMESTAMP(6);
SYS.TIMESTAMP_TZ_UNCONSTRAINED AS TIMESTAMP(6) WITH TIME ZONE;
SYS.TIMESTAMP_LTZ_UNCONSTRAINED AS TIMESTAMP(6) WITH LOCAL TIME ZONE;

NUMBER 数据类型系列

SYS.BINARY_INTEGER as integer;
SYS.SIMPLE_INTEGER as integer not null;
SYS.SIMPLE_FLOAT as BINARY_FLOAT not null;
SYS.SIMPLE_DOUBLE as BINARY_DOUBLE not null;
SYS.POSITIVE as integer check (value > 0);
SYS.positiven as integer check (value > 0) not null;
SYS."NATURAL" as integer check (value >= 0);
SYS.NATURALN as integer check (value >= 0) not null;
SYS.SIGNTYPE as integer CHECK (VALUE = -1 OR VALUE = 0 OR VALUE = 1);
PLS_INTEGER is INT(4);
REAL is FLOAT(4);
DOUBLE PRECISION is FLOAT(8);
DEC is NUMERIC;
BINARY_FLOAT is FLOAT(4);
BINARY_DOUBLE is FLOAT(8);

另请参阅

PL/SQL 数据类型`了解更多关于 PL/SQL 数据类型的信息 “:ref:`用户定义的 PL/SQL 子类型”，了解也适用于预定义子类型的信息