Dual Table

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

Questions by RAJAT RAHUL

Showing Answers 1 - 7 of 7 Answers


  • Jan 18th, 2016


  Was this answer useful?  Yes


  • Jan 19th, 2016

No we cannot update dual table. It is in-built table with one row and one column.

  Was this answer useful?  Yes

Anshul Nagar

  • Feb 3rd, 2016

We cannot update it, a dual table is a dummy table with one row and any no. of columns.

  Was this answer useful?  Yes


  • Feb 22nd, 2016

You can be update the Dual table, but you should have SYS schema access.

  Was this answer useful?  Yes

Ravi Teja

  • Feb 23rd, 2016

Yes. You can update and even alter the Dual table provided you are logged in with the SYS user. It is like normal table created by Oracle Database along with the data dictionary. You can drop the Dual table resulting many of the functions will not work properly. But you cant drop the column even though you are logged in with the SYS user.You can create a table with the name Dual in your Own schema.


  • 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.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions