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 the use of aggregate functions in oracle?
Explain the use of grant option in imp command.
What happens if the update subquery returns multiple rows?
How to create a new tablespace in oracle?
How to define an anonymous procedure with variables?
What are the predefined tablespaces in a database?
How to connect to a remote server?
defination of bitmap index
What happens if you use a wrong connect identifier?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to create a stored program unit?
Explain the use of control file?
What is blob data type in oracle?
How to define a procedure inside another procedure?
What is the dynamic sql in oracle?
