Editing SQL (section)

==SQL data types==
The SQL standard defines three kinds of [[data type]]s (chapter 4.1.1 of SQL/Foundation):
* predefined data types
* constructed types
* user-defined types.

''Constructed types'' are one of ARRAY, MULTISET, REF(erence), or ROW. ''User-defined types'' are comparable to classes in object-oriented language with their own constructors, observers, mutators, methods, inheritance, overloading, overwriting, interfaces, and so on. ''Predefined data types'' are intrinsically supported by the implementation.

===Predefined data types===
* Character types
** Character (CHAR)
** Character varying (VARCHAR)
** Character large object (CLOB)
* National character types
** National character (NCHAR)
** National character varying (NCHAR VARYING)
** National character large object (NCLOB)
* Binary types
** Binary (BINARY)
** Binary varying (VARBINARY)
** Binary large object (BLOB)
* Numeric types
** Exact numeric types (NUMERIC, DECIMAL, SMALLINT, INTEGER, BIGINT)
** Approximate numeric types (FLOAT, REAL, DOUBLE PRECISION)
** Decimal floating-point type (DECFLOAT)
* Datetime types (DATE, TIME, TIMESTAMP)
* Interval type (INTERVAL)
* Boolean
* XML (see [[SQL/XML]])<ref>{{Cite web |last= |date=November 2003 |title=SQL 2003 Standard Support in Oracle Database 10g |url=https://www.oracle.com/technetwork/database/sql-2003-twp-129141.pdf |access-date=27 March 2024 |website=Oracle |publisher=[[Oracle Corporation]] |language=en-us |archive-date=27 March 2024 |archive-url=https://web.archive.org/web/20240327155056/https://www.oracle.com/technetwork/database/sql-2003-twp-129141.pdf |url-status=live }} XML supported was added in ANSI SQL 2003, part 14.</ref>
* [[JSON]]