Answer Posted / kiran kumar
DML operation can not perform on complex view
if the SELECT statement in a view contain in any one of the
following
1) DISTINCT operation
2) Aggregate functions
3) Group by or HAVING clause
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is a schema sql?
how to rename an existing table in mysql? : Sql dba
Can we update views in sql?
What is the current version of postgresql?
what is a view? : Sql dba
What is mutating table error?
What is the most common sql injection tool?
Is sql free?
What is a record in a database?
Is keyword pl sql?
How do you concatenate in sql?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
How do I view a procedure in sql?
Explain cursor types?
What are the types of functions in sql?
