Thursday, September 4, 2008

Dual table

The dual table is a special one row table presented by default in all oracle database installations. it is suitable for selecting a pseudocolumn such as sysdate or user. the table has a signle varchar2(1) column called dummy, that has a value 'x'. the owner of the dual is "sys", but it can be used by every user.

No comments: