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
What is relationship? How many types of relationship are there?
Why do we use joins?
What are different types of functions in sql?
What is the best partition size for windows 10?
How to get unique records from a table?
what is data integrity? : Sql dba
What is identity column in sql server?
Write an sql query to select all records from the table?
What is the difference between a database and a relational database?
What problem one might face while writing log information to a data-base table in pl/sql?
How many databases can sql express handle?
what is self join and what is the requirement of self join? : Sql dba
Why use stored procedures?
What is the primary key?
Does pl/sql support create command?
