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 would you determine who has added a row to a table?
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?
What is the mandatory setup in cyclecount ?
What is Restricted Mode of Instance Startup in Oracle?
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
What is chargeback invoice? How do we create it? : oracle accounts receivable
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
what are important reports in HRMS,GL,AP,AR in oracle apps?
3 Answers IBM, Pathway Technologies, Satyam, Techtimer, Wipro,
When creating a user, what permissions must you grant to allow them to connect to the database?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What Are Cross Validation & Adi?