From:Steve Adams
Date:25-Apr-2001 16:46
Subject:   What is dual?

The name implies that it is a table with dual singularity - namely one row and one column. It is useful when you need to execute a function using the SQL engine and need an arbitrary table with just one row to drive the query. For example

        select sysdate from dual;

Can anyone clear me about the dual table in the database?