Submitted Questions

  • Dual Table

    Is Dual Table updatable? If we update, will it impact the health of the database?

    Habib Ali

    • May 10th, 2016

    DUAL table is owned by SYS, and is updatable only under SYS account. But never make any changes to DUAL, as it is frequently used by Oracle optimizer to test Execution Plans.


    • Mar 29th, 2016

    No we can't update dual table because it is a dummy table. But it is possible to create a table named dual and you can insert, update and delete that table.