Oracle Datatypes

• CHAR.

  • The CHAR datatype stores fixed-length character strings.

• VARCHAR2 (VARCHAR).

  • The VARCHAR2 datatype stores variable-length character strings.

• NUMBER.

  • The NUMBER datatype stores fixed and floating-point numbers. You can optionally specify a precision (total number of digits) and scale (number of digits to the right of decimal point).

Notes: