# DUAL: Data Dictionary Single Row Table for test cases and value retrieval of singleton SQL functions. - Catalog: `DataDictionary` - Schema: `Invantive` - Alias: `dal` - Primary Keys: `DUMMY_INT32` - Label: Single Row This is a read-only table. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API. ## Table Columns The columns of the table `DUAL` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `dummy_blob_null` | `blob` | | ☐ | | | `dummy_blob` | `blob` | Dummy BLOB | ☑ | | | `dummy_bool_null` | `boolean` | | ☐ | | | `dummy_bool` | `boolean` | Dummy Boolean | ☑ | | | `dummy_char_null` | `char` | | ☐ | | | `dummy_char` | `char` | | ☑ | | | `dummy_date_null` | `date` | | ☐ | | | `dummy_date` | `date` | Dummy Date | ☑ | A date in UTC. | | `dummy_datetime_null` | `datetime` | | ☐ | | | `dummy_datetime` | `datetime` | Dummy Date/Time | ☑ | A timestamp in UTC. | | `dummy_decimal_null` | `decimal` | | ☐ | | | `dummy_decimal` | `decimal` | Dummy Decimal | ☑ | | | `dummy_double_above` | `double` | | ☑ | | | `dummy_double_below` | `double` | | ☑ | | | `dummy_double_null` | `double` | | ☐ | | | `dummy_double` | `double` | Dummy Double | ☑ | | | `dummy_float_null` | `float` | | ☐ | | | `dummy_float` | `float` | Dummy Float | ☑ | | | `dummy_guid_null` | `varchar2` | | ☐ | | | `dummy_guid` | `varchar2` | Dummy GUID | ☑ | | | `dummy_int16_null` | `number` | | ☐ | | | `dummy_int16` | `int16` | Dummy Integer (16-bits) | ☑ | | | `dummy_int32_null` | `number` | | ☐ | | | `dummy_int32` | `int32` | Dummy Integer (32-bits) | ☑ | | | `dummy_int64_null` | `number` | | ☐ | | | `dummy_int64` | `int64` | Dummy Integer (64-bits) | ☑ | | | `dummy_string_int64` | `varchar2`(20) | | ☐ | | | `dummy_string_null` | `varchar2`(1) | | ☐ | | | `dummy_string` | `varchar2`(1) | Dummy String | ☑ | | | `dummy_uint16` | `uint16` | Dummy uint16 | ☑ | | | `dummy_uint32` | `uint32` | Dummy uint32 | ☑ | | | `dummy_uint64` | `uint64` | Dummy uint64 | ☑ | |