Reference Manual
CHAPTER 15. System Tables
Column name |
Column type |
Column constraint |
Table constraints |
|---|---|---|---|
dummy_col |
INTEGER |
NOT NULL |
The DUMMY table is provided as a table that always has exactly one row. This can be useful for extracting information from the database, as in the following example that gets the current user ID and the current date from the database.
SELECT USER, today(*) FROM SYS.DUMMY
dummy_col This column is not used. It is present because a table cannot be created with no columns.