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

What is user managed backup in Oracle?

610


How to update a table row with a record?

597


What is the difference between sharding and partitioning?

499


What is materialized view in Oracle?

630


what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1693






How to establish administrator authentication to the server?

556


Is there an oracle sql query that aggregates multiple rows into one row?

542


Explain the use of compress option in exp command.

546


How do I use unicode codesets with the weblogic jdriver for oracle driver?

548


Name the various constraints used in oracle?

562


What is a read only transaction in oracle?

591


How to convert a date to char in oracle? Give one example.

583


What is a package ? What are the advantages of package ?

599


Point out the difference between user tables and data dictionary?

538


How to drop a stored procedure in oracle?

589