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

• Stored Procedures
  • Select stored procedure
  • Update stored procedure
  • Insert stored procedure
  • Delete stored procedure
• Views
  • Introduction to SQL Views
• Table Basics (Schema)
  • Create SQL Table
  • Foreign Key Constraint
  • SQL Data Types
  • Add / Alter SQL Column
  • Drop SQL Table