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
- 9674 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 the advantage of index in sql?
How do I make sql search faster?
how many columns can be used for creating index? : Sql dba
What is a left join?
Which join is default?
What is clustered index sql?
How many sql commands are there?
What is a boolean in sql?
what does it mean to have quoted_identifier on? : Sql dba
Which one is better sql or oracle?
How do I truncate a sql log file?
define data blocks ? : Sql dba
How much does sql certification cost?
What are the disadvantages of file system?
How do you define a foreign key?
