In PostgreSQL, the DUAL table is a special one-column, one-row table present by default. It is created as a view to easing porting problems, which allows code to remain compatible with Oracle SQL without obstructing the Postgres parser.

BY Best Interview Question ON 15 Apr 2020