Quick Search:
 
 The Oracle PL/SQL SMALLINT Data Type      [Return To Index] Jump to:  

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)



Related Links:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org