Answer Posted / swapna
We can use 'instead of triggers' for views.Using these
instead of triggers we can perform DML operations on a
complex view.In complex views we can not perform DML
operations.But using instead of triggers we can insert ,
delete,update from complex views.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What is sql keyword?
What do you mean by “trigger” in sql?
Explain the working of foreign key?
What are procedures used for?
Explain what is dbms?
Does execute immediate commit?
Which function is used to return remainder in a division operator in sql?
Explain the savepoint statement.
how to calculate expressions with sql statements? : Sql dba
What are the sql aggregate functions?
What is the difference between partition and index?
what is single byte over head in oracle..?
Can you have more than one key in a database?
What is the difference between rollback and rollback to statements?