what is the difference between varchar2 and nvarchar2 in oracle?
The NVARCHAR2 stores variable-length character data. ... VARCHAR2 The maximum size of VARCHAR2 can be in either bytes or characters. Its column only can store characters in the default character set while the NVARCHAR2 can store virtually any characters. A single character may require up to 4 bytes .