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
- 10579 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 to rename a table?
Is it possible for a table to have more than one foreign key?
What is database migration?
What are commit, rollback, and savepoint?
what is datawarehouse? : Sql dba
How do I view tables in sql developer?
How many sql commands are there?
What are the sql versions?
What are the differences between implicit and explicit cursors?
State some properties of relational databases?
How do I count duplicates in sql?
what is difference between delete and truncate commands? : Sql dba
Is a secondary key the same as a foreign key?
what is the difference between delete and truncate statement in sql? : Sql dba
explain the difference between bool, tinyint and bit. : Sql dba
