Oracle SQL Data Types
Overview
Oracle SQL Data Types in a tabular format. Data type in one column and the Description of the data types in the second column. We will use some important data types in the database columns in the upcoming tutorials.
SQL Data Types
| SQL Data Type | Description |
| VARCHAR2 (n)
VARCHAR (n) |
Variable character string of maximum length n, n between 1 and 4000 |
| CHAR (n) | Fixed character string of n bytes, n between 1 and 2000 |
| NCHAR , NVARCHAR | Character strings with a different character set than that of the database |
| DATE | The DATE data type |
| NUMBER (p, s) | Decimal numbers |
| RAW(n) | Binary data |
| LONG | Variable string up to 2GB |
| CLOB | Strings up to 4GB |
| BLOB | Binary data up to 4GB |
| CFILE | pointer to a text file |
| BFILE | pointer to a binary file |
The manipulation of unstructured data is only possible with programming languages like PL/SQL, etc. The data types for unstructured data are :
LONG, LONG RAW, LOBs, etc
