Talk:PLS INTEGER

From Oracle FAQ
Jump to: navigation, search

Please consider to correct the following: PLS_INTEGER is an own datatype and not a subtype of INTEGER. Opposedly, INTEGER is a subtype of NUMBER, which means INTEGER is internally a NUMBER with a constraint on it.

Actually (since 8i) PLS_INTEGER is defined as a subtype of BINARY_INTEGER which is a subtype of INTEGER:
 subtype INTEGER is NUMBER(38,0);
 subtype BINARY_INTEGER is INTEGER range '-2147483647'..2147483647;
 subtype pls_integer is binary_integer;
Michel Cadot 16:09, 15 September 2011 (UTC)