SQL | ORACLE 10G| Datatypes in SQL| Sql Tutorial | Lesson-2 in Sql.

 Datatypes in Sql:

1) Char.

2) Varchar/Varchar2

3) Number

4) Date

5) Largest Object

a. Character Large Object (CLOB).

b. Binary Large Object (BLOB).

Therefore Sql is not Case Sensitive .

1) Char :-

        Char Datatype Can Accept Characters Such as 

         'A-Z', 'a-z', '0-9', 'alphanumeric' - ('A12ct'), 'Special Character' - ('@', '$', '#', -----) .

Syntax:-

Char(size)

Example : char(6).

        Char Datatype follows fixed Length memory allocation Max Size -2000.

SIZE:- It is used to determine the number of characters that we can store

i) Whenever we mention char datatype, we have to mention size for IT.

ii) the max.Size that we can store is 2000 .

iii) It is a type of "fixed length Memory Allocation".