Answer Posted / 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 |
Post New Answer View All Answers
How to run create database statement again?
What are the restrictions on external table columns?
Explain cascading triggers.
Explain compound trigger in oracle?
How can we view last record added to a table?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is oracle rowcount?
How to list all indexes in your schema?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to create an oracle database manually?
Explain oracle 12c new features for developers?
How to use null as conditions in oracle?
Explain what are clusters?
What is backup in Oracle?
What are the ways tablespaces can be managed and how do they differ?
