There are various types of datatypes are there
Data type Syntax 
Oracle 10g 
Explanation 

Rowid  The format of the rowid is: BBBBBBB.RRRR.FFFFF Where BBBBBBB is the block in the database file; RRRR is the row in the block; FFFFF is the database file. 
Fixedlength binary data. Every record in the database has a physical address or rowid. 
Urowid(size)  Universal rowid. Where size is optional. 
Data Type Syntax 
Oracle 10g  Explanation 
char(size) 
Maximum size of 2000 bytes. 
Where size is the number of characters to store.

nchar(size) 
Maximum size of 2000 bytes. 
Where size is the number of characters to store.

nvarchar2(size) 
Maximum size of 4000 bytes. 
Where size is the number of characters to store.

Varchar2(size) 
Maximum size of 4000 bytes. 
Where size is the number of characters to store.

Long 
Maximum size of 2GB. 
Variablelength strings. (backward compatible) 
Raw 
Maximum size of 2000 bytes. 
Variablelength binary strings 
Long Raw 
Maximum size of 2GB. 
Variablelength binary strings. (backward

Data Type Syntax 
Oracle 10g  Explanation 
number(p,s) 
Precision can range from 1 to

Where p is the precision and s is the scale.

numeric(p,s) 
Precision can range from 1 to

Where p is the precision and s is the scale.

dec(p,s) 
Precision can range from 1 to

Where p is the precision and s is the scale.

decimal(p,s) 
Precision can range from 1 to

Where p is the precision and s is the scale.

Data Type Syntax 
Oracle 10g  Explanation 
Date 
A date between Jan 1, 4712


timestamp

Fractional second’s precisionmust be a number between 0

Includes year, month, day, hour, minute, and seconds.

Ask Question