How to update the simple views?give me example?if the table
having 100 records and created a view on this table. if i can
update the table then how to update the views
- 2 Answers
- 5684 Views
- Cap Gemini, Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / muzaffar ali umrani
if you update the table then view will be automatically update, no need to update view.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / sudipta santra
THIS IS IMMETIRIAL QUESTION.
IF THE VIEW IS SIMPLE VIEW THEN IF U UPDATE TABLE OR DIRECT
UPDATE ON VIEW THE SAME THINGS WILL HAPPEN.
| Is This Answer Correct ? | 2 Yes | 0 No |
i have marks in table,how to find total?
Describe what redo logs are.
What is database schema?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?
What is the difference between oracle media recovery and crash recovery?
What is supporting issues GL AP and AR?
Explain an ORA-01555
What does coalescing a tablespace do?
Oracle General 
