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

What is BBED in Oracle?

1162


Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2970


Difference between inner join vs where ?

1043


How to export data to a csv file?

1312


can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122


What is SQL access advisor in Oracle?

1197


How do I limit the number of rows returned by an oracle query after ordering?

1173


What is the implicit cursor in oracle?

1113


An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2052


How to create a new table by selecting rows from another table?

1103


What is MTTR advisor in Oracle?

1091


How to assign values to data fields in record variables?

1038


Can we write dml statement in function in oracle?

1089


How to increment dates by 1 in oracle?

1097


Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2974