Oracle Data Type-1

in an Oracle database, each relational table is made up of many columns. Assign a specific data type to each column to define the data type that will be stored in this column.

1, CHAR
A maximum of 2000 characters or bytes can be stored in a fixed-length format. The default designation is to store as a character, a fixed-length data type, and, when the number of bits is not sufficient, to add an empty glyd to the right of the fill.

2. VarChar and VARCHAR2
You can store up to 4000B in variable lengths, so you do not need an empty glyd to supplement it. VARCHAR2 is more suitable for use than varchar, and still retains VARCHAR in the Oracle database for compatibility reasons.

3, NCHAR
The data type of the NLS (national language supports, international language support) can only store Unicode character sets defined by the database NLS character set. This data type can store up to 2000B. You need to fill a space on the right side of the NCHAR if the column is not in place. For example:

4, NVARCHAR2
The NLS data type is equivalent to the VARCHAR2 data type. This data type can store up to 4000B. For example:

Oracle Data Type-1