Oracle Database Interview Question:

What Are the ANSI Data Types Supported in Oracle?

Submitted by: Administrator

The following ANSI data types are supported in Oracle:

* CHARACTER(n) / CHAR(n)
* CHARACTER VARYING(n) / CHAR VARYING(n)
* NATIONAL CHARACTER(n) / NATIONAL CHAR(n) / NCHAR(n)
* NATIONAL CHARACTER VARYING(n) / NATIONAL CHAR VARYING(n) / NCHAR VARYING(n)
* NUMERIC(p,s)
* DECIMAL(p,s)
* INTEGER / INT
* SMALLINT
* FLOAT
* DOUBLE PRECISION
* REAL

Submitted by: Administrator