oracal

[jay t]

what is use DUAL table. in oracal

[rajujrk]

the dual table is used in Oracle when you need to run SQL that does not logically have a table name
Eg:

SELECT SYSDATE FROM DUAL;

SELECT extract(YEAR FROM DATE '2011-08-22') FROM DUAL;

SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') FROM DUAL;