Can a view be updated/inserted/deleted?If Yes under what
conditions?
Answers were Sorted based on User's Feedback
Answer / guest
A View can be updated/deleted/inserted if it has only one
base table if the view is based on columns from one or
more tables then insert, update and delete is not possible.
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / anurag
Also with the help of instead of trigger we can update the
view
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / swapnareddy
A View can be updated/deleted/inserted if it has only one
base table if the view is based on columns from one or
more tables then insert, update and delete is possible with
thehelp of instead of trigger.
Is This Answer Correct ? | 5 Yes | 2 No |
Why truncate is faster than delete?
What is t sql in sql server?
what is julian date in oracle
How is use pl and sql?
What are the different operators available in sql?
What is right join sql?
Does google use sql?
What is dcl in sql?
Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.
what are date and time functions in mysql? : Sql dba
What is a parameter query?
what is difference between procedure and function
10 Answers MCN Solutions, Wipro,