Month: June 2024

Character and Binary String Types-Datatypes

The character datatypes in Oracle are CHAR, VARCHAR2, and their ā€œNā€ variants. The CHAR and NCHAR can store up to 2000 bytes of text. The VARCHAR2 and NVARCHAR2 can store up to 4000 bytes of information. Note Starting with Oracle 12c, VARCHAR2, NVARCHAR2, and RAW datatypes can be configured to store up to 32,767 bytes Read More