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 |
Dummy BLOB | fetched only when named | ||
dummy_ |
blob |
fetched only when named | |||
dummy_ |
boolean |
Dummy Boolean | fetched only when named | ||
dummy_ |
boolean |
fetched only when named | |||
dummy_ |
char |
fetched only when named | |||
dummy_ |
char |
fetched only when named | |||
dummy_ |
date |
Dummy Date | fetched only when named | A date in UTC. | |
dummy_ |
date |
fetched only when named | |||
dummy_ |
datetime |
Dummy Date/Time | fetched only when named | A timestamp in UTC. | |
dummy_ |
datetime |
fetched only when named | |||
dummy_ |
decimal |
Dummy Decimal | fetched only when named | ||
dummy_ |
decimal |
fetched only when named | |||
dummy_ |
double |
Dummy Double | fetched only when named | ||
dummy_ |
double |
fetched only when named | |||
dummy_ |
double |
fetched only when named | |||
dummy_ |
double |
fetched only when named | |||
dummy_ |
float |
Dummy Float | fetched only when named | ||
dummy_ |
float |
fetched only when named | |||
dummy_ |
varchar2 |
Dummy GUID | fetched only when named | ||
dummy_ |
varchar2 |
fetched only when named | |||
dummy_ |
int16 |
Dummy Integer (16-bits) | fetched only when named | ||
dummy_ |
number |
fetched only when named | |||
dummy_ |
int32 |
Dummy Integer (32-bits) | fetched only when named | ||
dummy_ |
number |
fetched only when named | |||
dummy_ |
int64 |
Dummy Integer (64-bits) | fetched only when named | ||
dummy_ |
number |
fetched only when named | |||
dummy_ |
varchar2 |
fetched only when named | An IPv6 address, from the documentation range 2001:db8::/32. | ||
dummy_ |
varchar2 |
fetched only when named | An IPv4 address in IPv4-mapped IPv6 notation, the form the engine stores it in. | ||
dummy_ |
varchar2 |
fetched only when named | Always null, to exercise the absence of an IP address. | ||
dummy_ |
varchar2 |
Dummy String | fetched only when named | ||
dummy_ |
varchar2 |
fetched only when named | |||
dummy_ |
varchar2 |
fetched only when named | |||
dummy_ |
uint16 |
Dummy uint16 | fetched only when named | ||
dummy_ |
uint32 |
Dummy uint32 | fetched only when named | ||
dummy_ |
uint64 |
Dummy uint64 | fetched only when named |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: