General MySQL Oracle SQL Server

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

 

⇒ Text Literals in Oracle

⇐ Differences between BLOB and CLOB in Oracle

⇑ Understanding SQL Language Basics for Oracle

⇑⇑ Oracle Database Tutorials

2020-04-14, 2538🔥, 0💬

General MySQL Oracle SQL Server