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
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 |
how to replace not in with not exist?
which one is currently in used software cmpanies.
What is the difference between the SQL*Loader and IMPORT utilities?
What is the use of lockboxes? : oracle accounts receivable
how to create an user in oracle 10g.please give me an example..
what are important reports in HRMS,GL,AP,AR in oracle apps?
3 Answers IBM, Pathway Technologies, Satyam, Techtimer, Wipro,
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
Could you please let me know the interfaces in OM / FA??
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is difference b/w Credit memo and Adjustment in AR.
What view would you use to look at the size of a data file?