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
- 8744 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
What is recursive join in sql?
What is difference between primary and secondary key?
what is the difference between group by and order by in sql? : Sql dba
What is the usage of distinct keyword?
What is integrity in sql?
Does pl/sql support create command?
Is a table valued function object?
What is scalar function?
what are date and time data types? : Sql dba
What do you understand by case manipulation functions?
What is meant by user defined function?
How many postgresql users are there, worldwide?
What is difference between sql and mysql?
Can there be more than one function with a similar name in a pl/sql block?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
