Datatype | Description |
VARCHAR2(n) | A text string with variable length. Specify the maximum length (1 - 4,000 characters). Oracle version 7 only supports a maximum of 2,000 characters. |
NUMBER(p,s) | Number. Specify the total number of digits (p), up to 38. Specify the number of digits to the right of the decimal place(s), from -87 to 127. |
DATE | Date and time. Valid date range from January 1, 4712 BC to December 31, 4712 AD. |
CHAR(n) | A text string with a fixed length. Specify the exact length (1 - 255). |
LONG | Long binary file. Good for storing images, documents, audio, and so on. Maximum size is two gigabytes. |
RAW(n) | Raw binary data with variable length of up to 2,000 characters. Good for small graphics and documents. |
BLOB, CLOB, NCLOB | These are large objects. Good for audio, video, and other high-volume data items. Each can store up to four gigabytes in a single row or column. |
BFILE | A large object that is stored in a file system outside of the database itself, accessible from both inside outside the database. |