ANSI Data Types in Oracle

Q

What Are the ANSI Data Types Supported in Oracle in Oracle?

✍: 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

 

Understanding SQL Language Basics for Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 127👍, 0💬