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?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data type in oracle?

1100


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1978


What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1033


What is different types of joins?

1009


How to execute the package in oracle?

1071


What are the common oracle dba tasks?

1127


Explain the difference between a procedure and a function?

1147


How to delete a user account in oracle?

955


How to start an oracle instance?

1005


How does the on-delete-cascade statement work?

1091


15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2283


Explain the use of rows option in exp command.

1072


How to execute a stored program unit?

1053


How to estimate disk space needed for an export job?

1032


What is the minimum client footprint required to connect c# to an oracle database?

1077