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. |
Fixed-length 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. |
Variable-length strings. (backward compatible) |
Raw |
Maximum size of 2000 bytes. |
Variable-length binary strings |
Long Raw |
Maximum size of 2GB. |
Variable-length 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