Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers
Home / Oracle / Database / Q: Can a view be updated/inserted/deleted? If Yes under what conditions ?

Q: Can a view be updated/inserted/deleted? If Yes under what conditions ?
Print
Email to friend
Add comment
Views: 1103
Votes: 2
Comments: 3
A: A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible. 
Showing: 1-3 of 3  
Comments

14 Jul, 2008   |   mahendra baisane
There are two types of view simple view and complex view.we perform DML operation on simple view rather than complex view
20 Jun, 2008   |   Pravat Kumar Jena
Yes, a view can be inserted,upadated and deleted.
A simple view(one base table) can be inserted,updated and deleted directly by using DML Commands but a complex view(multiple base table with join condition) can be inserted,updated and deleted through in stead of trigger.Before DML operation there should be sufficient previllages.
13 Jun, 2008   |   nisha
yes a view can be inserted updated deleted provided the column is not used in the main query.
Add comment

Others in this Category
document What is Aggregate Functions?
document What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
document What is BCP? When does it used?
document What is CTE?
document Q: how to know the days or months or years between two employees in emp table?
document Q: What is normalization?
document Q: What is ON DELETE CASCADE ?
document What is B-Tree?
document What is difference between DELETE & TRUNCATE commands?
document What is Index?
» More articles


RSS
Powered by KBPublisher (Knowledge base software)