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 |
Can we insert data in view oracle?
How do I find my oracle client driver version?
What is Segment Advisor in Oracle?
How to write a query with a full outer join in oracle?
12 RULES OF RDBMS
does the query needs a hint to access a materialized view?
How to drop a stored procedure in oracle?
What to do if the startbd.bat failed to start the xe instance?
what is difference between DBMS and RDBMS?
What is a parameter file in oracle?
How many memory layers are in the shared pool?
What are set operators?