Here’s brief description about Oracle Character Data Types In SQL

• VARCHAR2

• Variable-length character strings

• Maximum of 4,000 characters

• Must specify maximum width allowed

• No trailing blank spaces are added

• Example declaration:

student_name VARCHAR2(30)

Character Data Types

• CHAR

• Fixed-length character data

• Maximum size 2000 characters

• Must specify maximum width allowed

• Adds trailing blank spaces to pad width

• Example declaration:

student_gender CHAR(1)

Character Data Types

• NCHAR

• Supports 16-digit binary character codes

• Used for alternate alphabets