ratnesh

• Jan 18th, 2016

 

NO

sujata

• Jan 19th, 2016

 

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

Anshul Nagar

• Feb 3rd, 2016

 

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

Venkat

• Feb 22nd, 2016

 

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

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.

vishal

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

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.