Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL SMALLINT Data Type      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 50 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?