---
title: "DOUBLE (Data Dictionary)"
description: "Single Row"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.DOUBLE
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.DOUBLE
updated: 2026-11-01T16:08:19Z
license: https://documentation.invantive.eu/en/
---

# DOUBLE: Data Dictionary Single Row

`read only`

- Catalog: `DataDictionary`
- Schema: `Invantive`
- Primary Keys: `DUMMY_INT32`
- Label: Single Row

Table for test cases and value retrieval of singleton SQL functions.

Can only retrieve data.

## Table Columns

The columns of the table `DOUBLE` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `dummy_blob` | `blob` | Dummy BLOB | [x] | fetched only when named |  |
| `dummy_blob_null` | `blob` |  | [ ] | fetched only when named |  |
| `dummy_bool` | `boolean` | Dummy Boolean | [x] | fetched only when named |  |
| `dummy_bool_null` | `boolean` |  | [ ] | fetched only when named |  |
| `dummy_char` | `char` |  | [x] | fetched only when named |  |
| `dummy_char_null` | `char` |  | [ ] | fetched only when named |  |
| `dummy_date` | `date` | Dummy Date | [x] | fetched only when named | A date in UTC. |
| `dummy_date_null` | `date` |  | [ ] | fetched only when named |  |
| `dummy_datetime` | `datetime` | Dummy Date/Time | [x] | fetched only when named | A timestamp in UTC. |
| `dummy_datetime_null` | `datetime` |  | [ ] | fetched only when named |  |
| `dummy_decimal` | `decimal` | Dummy Decimal | [x] | fetched only when named |  |
| `dummy_decimal_null` | `decimal` |  | [ ] | fetched only when named |  |
| `dummy_double` | `double` | Dummy Double | [x] | fetched only when named |  |
| `dummy_double_above` | `double` |  | [x] | fetched only when named |  |
| `dummy_double_below` | `double` |  | [x] | fetched only when named |  |
| `dummy_double_null` | `double` |  | [ ] | fetched only when named |  |
| `dummy_float` | `float` | Dummy Float | [x] | fetched only when named |  |
| `dummy_float_null` | `float` |  | [ ] | fetched only when named |  |
| `dummy_guid` | `varchar2` | Dummy GUID | [x] | fetched only when named |  |
| `dummy_guid_null` | `varchar2` |  | [ ] | fetched only when named |  |
| `dummy_int16` | `int16` | Dummy Integer (16-bits) | [x] | fetched only when named |  |
| `dummy_int16_null` | `number` |  | [ ] | fetched only when named |  |
| `dummy_int32` | `int32` | Dummy Integer (32-bits) | [x] | fetched only when named |  |
| `dummy_int32_null` | `number` |  | [ ] | fetched only when named |  |
| `dummy_int64` | `int64` | Dummy Integer (64-bits) | [x] | fetched only when named |  |
| `dummy_int64_null` | `number` |  | [ ] | fetched only when named |  |
| `dummy_ipv6` | `varchar2(45)` |  | [x] | fetched only when named | An IPv6 address, from the documentation range 2001:db8::/32. |
| `dummy_ipv6_mapped_ipv4` | `varchar2(45)` |  | [x] | fetched only when named | An IPv4 address in IPv4-mapped IPv6 notation, the form the engine stores it in. |
| `dummy_ipv6_null` | `varchar2(45)` |  | [ ] | fetched only when named | Always null, to exercise the absence of an IP address. |
| `dummy_string` | `varchar2(1)` | Dummy String | [x] | fetched only when named |  |
| `dummy_string_int64` | `varchar2(20)` |  | [ ] | fetched only when named |  |
| `dummy_string_null` | `varchar2(1)` |  | [ ] | fetched only when named |  |
| `dummy_uint16` | `uint16` | Dummy uint16 | [x] | fetched only when named |  |
| `dummy_uint32` | `uint32` | Dummy uint32 | [x] | fetched only when named |  |
| `dummy_uint64` | `uint64` | Dummy uint64 | [x] | fetched only when named |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Data Dictionary](/en/release-notes/drivers?driver=data-dictionary)

