Term: SMALLINT

Definition:
In Oracle PL/SQL, SMALLINT is an ANSI SQL data type which is supported by Oracle as NUMBER(38). It use is supported in SQL as well as PL/SQL operations.

Example Syntax:

[COLUMN | VARIABLE NAME] SMALLINT

Example Usage:

The example below shows that a SMALLINT column in a table is treated as NUMBER(38) by Oracle.

SQL> CREATE TABLE test (

  2  ID1          NUMBER,

  3  ID2         SMALLINT);



Table created.



SQL> desc test

 Name                                      Null?    Type

 ----------------------------------------- -------- -----------------------

 ID1                                                NUMBER

 ID2                                                NUMBER(38)