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 constraint?
Can a procedure in a package be overloaded?
What is fmtonly in sql?
what is single byte over head in oracle..?
In pl/sql, what is bulk binding, and when/how would it help performance?
what happens if null values are involved in expressions? : Sql dba
What is the maximum number of rows in sql table?
how to run 'mysql' commands from a batch file? : Sql dba
What are tables in sql?
What is an example of translating a date into julian format?
What does an inner join do?
how can we know the count/number of elements of an array? : Sql dba
How do you pronounce sql?
What is cursor explain with example?
Mention what is the use of function "module procedure" in pl/sql?