Snapshot of this Topic
01. Basic
02. Variables
VARCHAR2 (size) |
Variable length character string having maximum length size bytes you must specify size |
NVARCHAR2 (size) |
Variable length national character set string having maximum length size bytes.
You must specify size |
VARCHAR |
Now deprecated - VARCHAR is a synonym for VARCHAR2 but this usage may change in future versions. |
CHAR (size) |
Fixed length character data of length size bytes. This should be used for fixed length data. Such as codes A100, B102... |
NCHAR (size) |
Fixed length national character set data of length size bytes. This should be used for fixed length data. Such as codes A100, B102... |
NUMBER (p, s) |
Number having precision p and scales |
PLS_INTEGER |
signed integers
PLS_INTEGER values require less storage and provide better performance than NUMBER values.
So use PLS_INTEGER where you can! |
BINARY_INTEGER |
signed integers (older slower version of PLS_INTEGER) |
LONG |
Character data of variable length (A bigger version the VARCHAR2 data type ) |
DATE |
Valid date range |
TIMESTAMP |
the number of digits in the fractional part of the SECOND date time field. (Fractional _seconds _ Precision) |
IMESTAMP |
(Fractional _ seconds_ precision) |
WITH {LOCAL} TIMEZONE |
As above with time zone displacement value |
INTERVAL YEAR (Year _ precision) TO MONTH |
Time in years and months, where year _ precision is the number of digits in the YEAR date time field. |
RAW (size) |
raw binary data of length size bytes. You must specify size for a RAW value. |
LONG RAW |
Raw binary data of variable length (not interpreted by PL/SQL) |
ROWID |
Hexadecimal string representing the unique address of a row in its table (primarily for values returned by the ROWID pseudo column.) |
UROWID |
Hex string representing the logical address of a row of an index-organized table |
MLSLABEL |
Binary format of an operating system label this data type is used with Trusted Oracle7. |
CLOB |
Character Large Object |
NCLOB |
National Character Large Object |
BFILE |
pointer to binary file on disk |
XML Type |
XML data |
