SYS.DUAL
The DUAL
table can be used in a SELECT
statement that references no other tables, but needs to return at least one row. Selecting from the DUAL
table is useful for computing a constant expression with the SELECT
statement. Because DUAL
has only one row, the constant is returned only once.
Columns
Column name | Type | Description |
---|---|---|
|
|
' |