if you update view? where we store the data?

Answer Posted / sivakumar

The value gets updated in base table. This is done by insteadof trigger

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How different is ms access and oracle?

535


How to increment dates by 1 in oracle?

550


What exactly do quotation marks around the table name do?

534


Explain temporal data types in oracle

588


A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

4237






Explain view?

571


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1451


Explain about your project and its relation to the current job position you are applying to?

526


How can we find out the current date and time in oracle?

632


How to commit the current transaction in oracle?

566


Explain the truncate in oracle?

537


What is bulk load in oracle?

580


How to retrieve data from an explicit cursor?

549


Can we insert data in view oracle?

521


Explain what are the characteristics of data files?

614