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 dual table in oracle?
What is bind variable in oracle 11g?
How to retrieve values from data fields in record variables?
Can group functions be used in the order by clause in oracle?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
can u plz provide me oca sql dumps please i need them
what are steps for interface? where is exchange rate defined in which table?
How to convert dates to characters in oracle?
What is a oracle database?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What is the difference between formal parameters and actual parameters?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Why is oracle database so popular?
What are the various constraints used in oracle?
defination of bitmap index
