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