invantive documentation
Invantive Support ForumsLog In / Sign Up

DUAL: 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 DUAL 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 fetched only when named
dummy_blob_null blob fetched only when named
dummy_bool boolean Dummy Boolean fetched only when named
dummy_bool_null boolean fetched only when named
dummy_char char fetched only when named
dummy_char_null char fetched only when named
dummy_date date Dummy Date fetched only when named A date in UTC.
dummy_date_null date fetched only when named
dummy_datetime datetime Dummy Date/Time fetched only when named A timestamp in UTC.
dummy_datetime_null datetime fetched only when named
dummy_decimal decimal Dummy Decimal fetched only when named
dummy_decimal_null decimal fetched only when named
dummy_double double Dummy Double fetched only when named
dummy_double_above double fetched only when named
dummy_double_below double fetched only when named
dummy_double_null double fetched only when named
dummy_float float Dummy Float fetched only when named
dummy_float_null float fetched only when named
dummy_guid varchar2 Dummy GUID fetched only when named
dummy_guid_null varchar2 fetched only when named
dummy_int16 int16 Dummy Integer (16-bits) fetched only when named
dummy_int16_null number fetched only when named
dummy_int32 int32 Dummy Integer (32-bits) fetched only when named
dummy_int32_null number fetched only when named
dummy_int64 int64 Dummy Integer (64-bits) fetched only when named
dummy_int64_null number fetched only when named
dummy_ipv6 varchar2(45) fetched only when named An IPv6 address, from the documentation range 2001:db8::/32.
dummy_ipv6_mapped_ipv4 varchar2(45) 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 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 fetched only when named
dummy_uint32 uint32 Dummy uint32 fetched only when named
dummy_uint64 uint64 Dummy uint64 fetched only when named

Release Notes

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