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
- 10454 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
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
Which are the different character-manipulation functions in sql?
How do I know if I have sql express or standard?
What is pl sql code?
Explain scalar functions in sql?
What is the command used to fetch the first 5 characters of a string?
What does (*) mean in sql?
What is nosql example?
What are all different types of collation sensitivity?
Why do we need databases?
How to start oracle sql developer?
Write a query to display the current date in sql?
What is the difference between an inner and outer join?
What is trigger with example?
Can we use threading in pl/sql?
