Interested to Buy Any Domain ? << Click Here >> for more details...
What is the relation b/w view and trigger
- 3 Answers
- 16680 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answer Posted / rajesh venati
View are classified in to two types.
1. Simple View
2. Complex View
==>DML Operations are not possible in complex views, because,
if u create a view more than one table or
if u create a view using group function or
if u create a view using distinct keyword etc.,
those are called complex view.
If u want perform DML Operations on Complex Views, then we
will go for Instead of Trigger.
Through the Instead of Triggers we can perform DML
Operations on a Complex View.
| Is This Answer Correct ? | 31 Yes | 1 No |
Post New Answer View All Answers
How do I find duplicates in two columns?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
how many tables will create when we create table, what are they? : Sql dba
What are the different types of database management systems?
What is trigger types in sql?
What view means?
What are different sql data types?
Is null operator in sql?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is cursor in pl sql with examples?
How do I filter in sql profiler?
Can we insert data into view?
What is optimistic concurrency control? : Transact sql
What are commit, rollback, and savepoint?
Is primary key is clustered index?
