Problems with the DUAL table

By Harish Kapgate – DUAL is a table automatically created by Oracle along with the data dictionary. It is in the schema of the user SYS, but is accessible by the name DUAL to all users. It has one column, DUMMY, defined to be VARCHAR2(1), and contains one row with a value ‘X’. Selecting from the DUA

Read More - Register for Free Membership