Interested to Buy Any Domain ? << Click Here >> for more details...
a. Can you delete data from a View.
b. If Yes, can you delete it if there are multiple tables
c. If No, can you delete if there is single source table
which is joining.
- 4 Answers
- 10432 Views
- CGI, IBM, I also Faced
- E-Mail Answers
Answer Posted / haarika valasa
IF view is created based on only one base table we can
perform all DML operations.
If view is created based on multiple table using joins and
goup by functions etc..than we cannot perform directly DML
operations.
Using Instead of Trigger we can perform DML operations on
complex view.
| Is This Answer Correct ? | 24 Yes | 0 No |
Post New Answer View All Answers
What is type and rowtype in pl sql?
Explain the update statement in sql
What is basic structure of pl sql?
Mention what are the benefits of pl/sql packages?
Can we use pl sql in sql server?
What is crud diagram?
Which is the correct statement about truncate and delete?
How to prepare for oracle pl sql certification?
What is audit logout in sql profiler?
What is a call statement? Explain with an example.
Can procedure in package be overloaded?
Is sql a oracle?
What do you understand by pl/sql records?
what are the 'mysql' command line arguments? : Sql dba
How can you save or place your msg in a table?
