Differences between CHAR and VARCHAR in Oracle


What Are the Differences between CHAR and VARCHAR2 in Oracle?

✍: FYIcenter.com


The main differences between CHAR and VARCHAR2 are:

  • CHAR stores values in fixed lengths. Values are padded with space characters to match the specified length.
  • VARCHAR2 stores values in variable lengths. Values are not padded with any characters.


Differences between NUMBER and BINARY_FLOAT in Oracle

Differences between CHAR and NCHAR in Oracle

Understanding SQL Language Basics for Oracle

⇑⇑ Oracle Database Tutorials

2020-04-25, 1743🔥, 0💬