Oracle in World: Oracle datatype internal code representation

As it is shown in How can one dump/ examine the exact content of a database column? every datatype in oracle has its internal code. In this example every oracle datatype along with their corresponding internal code is shown.

Datatype                                                                      Code
--------------------------------------                                        -------
1. VARCHAR2(size [BYTE | CHAR])                                               01
2. NVARCHAR2(size)                                                            01
3. NUMBER[(precision [, scale]])                                              02
4. LONG                                                                       08
5. DATE                                                                       12
6. BINARY_FLOAT                                                               21
7. BINARY_DOUBLE                                                              22
8. RAW(size)                                                                  23
9. LONG RAW                                                                   24
10.ROWID                                                                      69
11.CHAR [(size [BYTE | CHAR])]                                                96
12.NCHAR[(size)]                                                              96
13.CLOB                                                                       112
14.NCLOB                                                                      112
15.BLOB                                                                       113
16.BFILE                                                                      114
17.TIMESTAMP [(fractional_seconds)]                                           180
18.TIMESTAMP [(fractional_seconds)] WITH TIME ZONE                            181
19.INTERVAL YEAR [(year_precision)] TO MONTH                                  182
20.INTERVAL DAY [(day_precision)] TO SECOND [(fractional_seconds)]            183
21.UROWID [(size)]                                                            208
22.TIMESTAMP [(fractional_seconds)] WITH LOCAL TIME ZONE                      231

Oracle in World

Monday, March 16, 2009

Oracle datatype internal code representation

No comments:

Post a Comment