Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is system tablespace?
What is private procedure oracle?
What is PL/SQL ?
Name the three major set of files on disk that compose a database in Oracle?
What privilege is needed for a user to create indexes in oracle?
if you ctreate table identity
How to create a server parameter file?
How to install oracle odbc drivers?
How to create an oracle testing table?
What is hash cluster in oracle?
what happened to the global index when I truncate the data in one of the partition?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to assign values to data fields in record variables?
Difference between oracle's plus (+) notation and ansi join notation?
How to create a table in a specific tablespace?
