Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert the data through views? The view is depending
upon more than two tables?
how to update materalized views?
- 3 Answers
- 8608 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
How to execute a stored procedure?
What is scope and visibility in PL/SQL?
what is a trigger in mysql? Define different types of trigger. : Sql dba
Can a composite key be null?
how to convert character strings to dates? : Sql dba
what are the different type of sql's statements ? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
How do I truncate a sql log file?
Which is faster union or join?
explain what is mysql? : Sql dba
Is left join and outer join same?
Which are the different character-manipulation functions in sql?
What is sql query limit?
Which table is left in join?
how to use case expression? : Sql dba
