posted Nov 10, 2011, 1:08 AM by Neil Mathew
[
updated Nov 10, 2011, 1:27 AM
]
Note: Noticed in oracle:
NUMBER ( 5, 2 ) is a floating type number which allows a column to have a 5digit number with two decimal places. That is, only 3 non-decimal places are allowed. eg: 300.02
I had some errors arising because I entered less digits in the decimal places or too many overall. Just a note.
| CHAR(size) | Fixed length character data of length size bytes. This should be used for fixed length data. Such as codes A100, B102... |
| VARCHAR2(size) | Variable length character string having maximum length sizebytes.
You must specify size |
| NUMBER(p,s) | Number having precision p and scale s. |
| LONG | Character data of variable length (A bigger version the VARCHAR2 datatype)
up to 2 Gbytes of data |
| RAW(size) | Raw binary data of length size bytes
used for byte-oriented data (to store character strings, floating point data, and binary data such as graphics images and digitized sound )
You must specify size for a RAW value. |
| LONG RAW | Raw binary data of variable length. (not intrepreted by PL/SQL) |
| NCLOB | National Character Large Object |
| BLOB | Binary Large Object
like graphics, sound,etc |
| CLOB | Character Large Object
like text,memos, etc |
| BFILE | pointer to binary file on disk |
The NUMBER datatype
Stores zero, positive, and negative numbers, fixed or floating-point numbers Fixed-point NUMBER
NUMBER(p,s)
precision p = length of the number in digits
scale s = places after the decimal point, or (for negative scale values) significant places before the decimal point.
Integer NUMBER
NUMBER(p)
This is a fixed-point number with precision p and scale 0. Equivalent to NUMBER(p,0)
Floating-Point NUMBER
NUMBER
floating-point number with decimal precision 38
|
|
