Thread: What are the different Data Types available in Oracle?

I want to join Oracle class. So before that I want little bit knowledge of the different data types which are used in the Oracle. If you have any knowledge about the data types of Oracle then share with me.

I am known about the following data type of Oracle:

• NCHAR

• NVARCHAR2

• LOB Character

• VARCHAR2

• VARCHAR

• LONG

• BLOB, CLOB, NCLOB, BFILE

• Date (Month, Hour, Minute, Year)

Following given oracle data types with its maximum range:

1. NCHAR(bytes):32,767 bytes

2. NVARCHAR(bytes):32,767 bytes

3. NCHAR VARYING(chars):32,767 bytes

4. STRING(chars):32,767 bytes

5. LONG:32,760 bytes

6. CHAR VARYING(chars):32,767 bytes