The Magic table DUAL is owned by User SYS as its an dictionary object. ind> select object_name,owner,object_type 2 from dba_objects 3 where object_name like ‘%DUAL%’; OBJECT_NAME OWNER OBJECT_TYPE ———— ———————- ——————- DUAL SYS TABLE DUAL PUBLIC SYNONYM 2 rows selected. ‘Dual’ is a special table with 1X1 (1 row and 1 column) owned by sys … Continue reading All about the DUAL