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
- 10264 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 select 10 records from a table?
What is difference sql and mysql?
What is normalization in sql?
What are the dml statements?
How long it takes to learn pl sql?
How many types of privileges are available in sql?
Is sql workbench free?
How can I speed up sql query?
What is sql used for?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What are the types of triggers in sql?
Define implicit and explicit cursors.
How many sql commands are there?
What is the purpose of a secondary key?
What is sql procedures and functions?
