ORACLE Data Types

Text Data Types

 
 varchar2    4000
 nvarchar2   4000
 char        2000
 nchar       2000 
 

Numeric Data Types

 
 number      21 
 long        2 GB
 rowid       10
 urowid      3950 
  

Date Data Types

 
 date                           10
 timestamp                      11  
 timestamp with time zone       13 
 interval year to month         5 
 interval day to second         11 
 timestamp with local time zone 11 

Binary Data Types

 
 raw         2000 
 long raw    2 GB 
 
 Collapse All    Expand All
Custom Search
< div id="sitebanner">

Oracle Information and Resources