how to insert the data through views? The view is depending
upon more than two tables?
how to update materalized views?
- 3 Answers
- 7793 Views
- 3i Infotech, I also Faced
- E-Mail Answers
Answer Posted / rajesh venati
If we create a view on more than one table, or using
distinct keyword or use any group functions it is called
complex view.
If we want perform DML operations on complex views the we
will go for Instead of Triggers.Through the instead of
triggers we can perform DML operations on complex views.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is output spooling in sql*plus?
What are different sql data types?
What is the order of sql select?
What does joining a thread mean?
explain the delete statements in sql
What is meaning of <> in sql?
What is an oracle stored procedure?
Are stored procedures faster than dynamic sql?
What are the two different parts of the pl/sql packages?
Explain character-manipulation functions?
What is %rowtype in pl sql?
Why self join is used in sql?
What is sql architecture?
Define union, minus, union all, intersect ?
What is replication id?
