developer

• Sep 11th, 2006

 

Hi,

No., We cannot perform DML operations on Dual table. because we dont have the access permissions on that table.

For security reasons,we hide data from the database then we use Views.If there are more transactions on the base table then we use materialized views.

New features of Oracle 9i are:

i)Merge statement  ii) Flashback query iii) Functionbased indexes iv) Materialised View enhancement and......

lieni

• Jul 30th, 2007

 

No., We cannot perform DML operations on Dual table. because we dont have the access permissions on that table.

I say: But if we have access, eg. sysdba, we can

For security reasons,we hide data from the database then we use Views.If there are more transactions on the base table then we use materialized views.

I say: a materialized view is a table withe the same structure like the under laying view, access to it, specially when the view has many joins becomes much faster. there is different methods to reupdate this materialized view. frequently, with a special command or as soon the underlaying tables changes.

You can index this materialized view

 

New features of Oracle 9i are:

i)Merge statement  ii) Flashback query iii) Function based indexes iv) Materialised View enhancement and......

Rajeshree Metkar

• Aug 10th, 2007

 

Hello,

As I go through the Comments related to the dual table I saw that there is a comment that we can not perform a DML operation on Dual table. Yes it is correct but only in case if you are log in through the client. If your login through Sys you are able to perform the all DML operation (for e.g. Insert,Update,Delete). 


Rajeshree Metkar