Oracle SQL - Introduction Data Types


Oracle supports many standard data types.

Some of the data types are synonyms for each other.

These data types are supported for compatibility purposes of Oracle with other DBMS systems or with the ANSI/ISO SQL standard.

For example, INT and INTEGER are synonyms for NUMBER(38).

There are three categories of column data:

  • numbers (numeric data),
  • text (alphanumeric data), and
  • time-related data.

The most important corresponding Oracle data types are NUMBER, VARCHAR or VARCHAR2, and DATE, respectively.