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.
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
Do we need to rebuild index after truncate?
How do I view a procedure in sql?
What is the difference between inner join and natural join?
What is full join in sql?
Enlist the data types that can be used in pl/sql?
What is sql keyword?
what is the difference between nested subquery and correlated subquery?
What is trigger explain it?
what is auto increment? : Sql dba
Explain what is rdbms?
Can you upgrade sql express to full sql?
Why join is faster than subquery?
discuss about myisam key cache. : Sql dba
Is sql dba a good career? : SQL DBA
What is the difference between nvl function, ifnull function, and isnull function?