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...

if you update view? where we store the data?

Answer Posted / ramesh.ch

The updated data will be stored in base table directly.


Explanation:

View is always reference for base table .view is a virtual
table.Unless a view is indexed,its data is not stored in
data base as a distinct element. only the select statement
is stored in the data base.If you call the select statement
of view ,it displays the data form base table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to see the table columns used in an index?

1017


What is format trigger?

2062


How to define an oracle sub procedure?

1136


How to execute a stored procedure in oracle?

1080


How to use subqueries with the exists operator in oracle?

1022


What is the relation of a user account and a schema?

1128


What is an anonymous block?

1233


Explain the use of constraints option in exp command.

1044


What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2351


What is a cursor and what are the steps need to be taken?

1196


How to invoke the data pump export utility?

1180


Why packages are used in oracle?

1064


What are the restrictions on external table columns?

1052


How to export your own schema?

1007


what are actual and formal parameters?

1104