SQL Plus - Can a view be updated/inserted/deleted

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 31 of 132

Can a view be updated/inserted/deleted

Total Answers and Comments: 6

Last Update: July 04, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: Venu.

A simple view can be updated/inserted/deleted but the complex view which is constructed by using multiple tables or by using group functions can't be updated/deleted/inserted directly for that we have to write instead-of-triggers.

Above answer was rated as good by the following members:
lovely sethii

July 07, 2005 06:48:47

Ramesh P

RE: Can a view be updated/inserted/deleted

A view can deleted/Inserted/updated

Is this answer useful? Yes | No

August 25, 2005 12:49:52

J Lehew

RE: Can a view be updated/inserted/deleted

There are restrictions since a view can join multiple tables and have functions and groupings it may not be possible to update a view. Simple views on one table can definately be updateable.

Is this answer useful? Yes | No

November 24, 2005 05:50:46

Venu.

RE: Can a view be updated/inserted/deleted

Is this answer useful? Yes | No

1 0

Overall Rating: +1

May 31, 2006 08:37:57

narasimhulu

Member Since: May 2006 Contribution: 4

RE: Can a view be updated/inserted/deleted

Yes a view can be updated/inserted/deleted only if it is based on single base table means it should be a simple view.

Is this answer useful? Yes | No

November 07, 2006 13:19:29

Srikanth

RE: Can a view be updated/inserted/deleted

a view can be manpulated by using instead of triggers

Is this answer useful? Yes | No

June 24, 2008 11:45:35

sweetytrivedi

Member Since: June 2008 Contribution: 7

RE: Can a view be updated/inserted/deleted

If a view is based upon a single table then DML operations can be performed on it while if a view is based upon more than two tables then it is a complex view and DML operations can be performed using instead of triggers.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank