What is the dual table in Oracle

It’s a sort of dummy table with a single record used for selecting when you’re not actually interested in the data, but instead want the results of some system function in a select statement: e.g.¬†select sysdate from dual; dual¬†is a table which is created by oracle along with ... Read more