there are some of the data types used by the oracle :
1. :
Fixed length storage of string. The default length of the CHAR is 1 and maximum size of the CHAR is 254.
2. NCHAR :
3. VARCHAR2
4. NVARCHAR2
5. VARCHAR
6. NUMBER
7. DATE
8. LONG
10 TIMESTAMP
11 BFILE
12 BLOB
13 CLOB
14 NCLOB
15 INT
1. :
Fixed length storage of string. The default length of the CHAR is 1 and maximum size of the CHAR is 254.
2. NCHAR :
3. VARCHAR2
4. NVARCHAR2
5. VARCHAR
6. NUMBER
7. DATE
8. LONG
10 TIMESTAMP
11 BFILE
12 BLOB
13 CLOB
14 NCLOB
15 INT
