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
Answer Posted / 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 |
Post New Answer View All Answers
1. What is PO rate variance gain and loss?
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
where the dff data will be stored
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?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Difference between transaction type and transaction sources. : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
can we use lexical perameter in oracle plsql if yes how
What is the difference between conversions and interfaces? : oracle accounts receivable
what is the link between suppliers and banks in ap module in oracle apps? And also query?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.