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
- 8582 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
When you have to use a default "rollback to" savepoint of plvlog?
Is sql sequential or random?
explain the difference between bool, tinyint and bit. : Sql dba
Is sql between inclusive?
What is the most important ddl statements in sql are?
What are the advantages of sql?
what does the t-sql command ident_incr does? : Transact sql
What is primary and foreign key?
What is the current version of postgresql?
What is flag in sql?
What is coalesce in sql?
How can you create an empty table from an existing table?
How to use transactions efficiently : transact sql
what is timestamp in mysql? : Sql dba
What is a rank in sql?
