Updated on 2026-02-06 GMT+08:00

DUAL

The DUAL view is a virtual view created by the system. It has one row and one column and is mainly used to execute queries that do not require actual data tables. It is accessible to all users. This view exists in the PG_CATALOG and SYS schemas.

Table 1 DUAL columns

Name

Type

Description

DUMMY

text

Fixed content "X".