The jOOQ User Manual SQL building Data types Built-in data types DECIMAL INTEGER (BigInteger)

previous : next

DECIMAL INTEGER (BigInteger)

Supported by ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The DECIMAL_INTEGER data type represents a zero-scale decimal number, or java.math.BigInteger in Java. It has no representation in JDBC.

Given the variable precision characteristic, the DECIMAL_INTEGER type should usually be accompanied by an explicit precision flag. If absent, the default behaviour is dialect specific.

DDL support

Dialect support

This example using jOOQ:

createTable("t").column("c", DECIMAL_INTEGER(10))

Translates to the following dialect specific expressions:

Access, SQLDataWarehouse, SQLServer, Teradata

CREATE TABLE t (
  c numeric(10)
)

ASE, Sybase

CREATE TABLE t (
  c decimal(10) NULL
)

Aurora MySQL, Aurora Postgres, CockroachDB, DB2, Derby, DuckDB, Exasol, Firebird, H2, HSQLDB, Hana, Informix, MariaDB, MemSQL, MySQL, Postgres, Redshift, Snowflake, Trino, Vertica, YugabyteDB

CREATE TABLE t (
  c decimal(10)
)

BigQuery

CREATE TABLE t (
  c decimal
)

ClickHouse

CREATE TABLE t (
  c Nullable(decimal(10))
)
ENGINE Log()

Databricks

CREATE TABLE t (
  c decimal(10)
)
TBLPROPERTIES(
  'delta.columnMapping.mode' = 'name',
  'delta.feature.allowColumnDefaults' = 'supported'
)

Oracle

CREATE TABLE t (
  c number(10)
)

SQLite

CREATE TABLE t (
  c unsigned big int(10)
)

Cast support

Dialect support

This example using jOOQ:

cast(field("c"), DECIMAL_INTEGER(10))

Translates to the following dialect specific expressions:

Access

cdec(c)

ASE, Aurora MySQL, Aurora Postgres, CockroachDB, DB2, Databricks, Derby, DuckDB, Exasol, Firebird, H2, HSQLDB, Hana, Informix, MariaDB, MemSQL, MySQL, Postgres, Redshift, Snowflake, Sybase, Trino, Vertica, YugabyteDB

CAST(c AS decimal(10))

BigQuery

CAST(c AS decimal)

ClickHouse

CAST(c AS Nullable(decimal(10)))

Oracle

CAST(c AS number(10))

SQLDataWarehouse, SQLServer, Teradata

CAST(c AS numeric(10))

SQLite

CAST(c AS unsigned big int(10))

The jOOQ User Manual SQL building Data types Built-in data types DECIMAL INTEGER (BigInteger)

previous : next