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
Give the various exception types.
What is parameterized cursor in oracle?
Explain an index segment?
How to turn on or off recycle bin for the session?
How to start a new transaction in oracle?
what is the dual table in oracle?
 How to use an oracle sequence generator in a mapping?
What is a view and how is it different from a table?
How to specify default values in insert statement using oracle?
How to create lov dynamically at runtime & attach to text field?
What would you do with an in-doubt distributed transaction?
How to create a table interactively?
Is there a function to split a string in plsql?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to join two tables in a single query using oracle?