SQL Server Information and Resources Bookmark this page

SQLINFO.net is a Community Service from DataExpressions makers of dbOrchestra©

Google
 

 

 

 


Oracle Code Examples

SQL DML

String Functions

Stored Procedures

SQL Views

SQL Table Basics


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 
 
  
      


Copyright 2006-2007 by DataExpressions --- All Rights Reserved            dbOrchestra - Oracle home page