can a view be updated?

Answers were Sorted based on User's Feedback



can a view be updated?..

Answer / yogesh babu

yes it can be updated ....but there are certain
restrictions in it.
For eg:
1.a view created from nonupdatable view cant be updated
2.when it is having having , groupby,orderby it cant be
updated.etc

Is This Answer Correct ?    9 Yes 1 No

can a view be updated?..

Answer / kumar

View can be updated ...but some restrictions are there.

Let us think we are using one or more tables to create a
view and if the view contains all the NOT NULL constraint
columns of the tables, then only we can update the view or
else we can't.

Is This Answer Correct ?    4 Yes 1 No

can a view be updated?..

Answer / 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

More Oracle General Interview Questions

Can we insert data in view oracle?

0 Answers  


How do I find my oracle client driver version?

0 Answers  


What is Segment Advisor in Oracle?

0 Answers   MCN Solutions,


How to write a query with a full outer join in oracle?

1 Answers  


12 RULES OF RDBMS

1 Answers  






does the query needs a hint to access a materialized view?

0 Answers  


How to drop a stored procedure in oracle?

0 Answers  


What to do if the startbd.bat failed to start the xe instance?

0 Answers  


what is difference between DBMS and RDBMS?

2 Answers   Metric Stream,


What is a parameter file in oracle?

0 Answers  


How many memory layers are in the shared pool?

1 Answers  


What are set operators?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)