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
- 10588 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 dml and ddl?
What is the difference between left outer join and left join?
How do I enable sql encryption?
Which one is better subquery or joins?
Which table is left in left join?
What are inbuilt functions in sql?
Can I learn sql in a week?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Why do we create stored procedures & functions in pl/sql and how are they different?
What is full join in sql?
Why is stored procedure faster than query?
How do I partition in sql?
Is foreign key mandatory?
What is a common use of group by in sql?
What is sql entity?
