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
How do I call oracle stored procedures that take no parameters?
How to delete a user account in oracle?
How to use "out" parameter properly?
How oracle handles dead locks?
What is a initialization parameter file in oracle?
How to put more than 1000 values into an oracle in clause?
What is the difference between Delete, Truncate and Drop in Oracle?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What is the fastest query method to fetch data from the table?
How to get last row id?
How do you tell what your machine name is and what is its IP address?
How to write an inner join with the where clause in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What is format trigger?
