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 the use of primary key?
what is the command line end user interface - mysql? : Sql dba
How do you modify a trigger?
How do I edit a trigger in sql developer?
What is sap sql anywhere?
Can you do multiple joins in sql?
What is t sql used for?
Why do you partition data?
What does (+) mean in sql joins?
What normalization means?
what is schema? : Sql dba
Is a foreign key always unique?
What is the use of index in hive?
What are %type and %rowtype for?
Which are the different case manipulation functions in sql?
