What Are the ANSI Data Types Supported in Oracle

Q

What Are the ANSI Data Types Supported in Oracle? - Oracle DBA FAQ - Understanding SQL Basics

✍: FYIcenter.com

A

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

2007-04-24, 4750👍, 0💬