| 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?
|