Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Can a view be updated/inserted/deleted?If Yes under what
conditions?

Answer Posted / swapnareddy

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 possible with
thehelp of instead of trigger.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is a primary key important?

1102


What is the life of an sql statement?

1073


What is sql deadlock?

1215


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2067


What is a sql trace file?

1085


What is primary key and foreign key?

1010


Why do we need cursor in pl sql?

1187


What is full join in sql?

1033


what is oltp (online transaction processing)? : Sql dba

1125


what is clause? : Sql dba

1116


What are tuples in sql?

1197


how do you tune the slow running queries in oracle db , explain the methodology

3215


What are the packages in pl sql?

1063


What is a composite primary key?

1142


Can we commit inside a trigger?

1047