can a view be updated?
Answers were Sorted based on User's Feedback
Answer / yogesh babu
yes it can be updated ....but there are certain
restrictions in it.
For eg:
1.a view created from nonupdatable view cant be updated
2.when it is having having , groupby,orderby it cant be
updated.etc
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / kumar
View can be updated ...but some restrictions are there.
Let us think we are using one or more tables to create a
view and if the view contains all the NOT NULL constraint
columns of the tables, then only we can update the view or
else we can't.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / chandana
Yes,Views can be updated but there are some conditions.
-> Depending on type of view ie
Simple views can be updated
Complex views may or may not be updated.
One cannot Perform DML Operations on Complex view
if it contains
1. Group by clause
2. Group functions
3. Distinct
4. Pseudocolumn rownum
One cannot modify the view if it has
1. Group by clause
2. Group functions
3. Distinct
4. Pseudocolumn rownum
5. Columns by expressions
One cannot insert data into views if it has
1. Group by clause
2. Group functions
3. Distinct
4. Pseudocolumn rownum
5. Columns by expressions
6. NOT NULL columns in base table that are not selected in
view
Is This Answer Correct ? | 3 Yes | 3 No |
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
Give the different types of rollback segments.
What is a sub query? What are its various types?
pls explain connect by prior with example and its real time use
What types of joins are used in writing subqueries?
when loggined as SYSTEM,how to display all the users of database using sql query?
What is translate in oracle?
How to list all indexes in your schema?
Why do we use bulk collect in oracle?
What are the different types of modules in oracle forms?
Explain integrity constraints?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.