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


Please Help Members By Posting Answers For Below Questions

1. What is PO rate variance gain and loss?

2312


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

1902


where the dff data will be stored

1801


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?

700


HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

1585






Difference between transaction type and transaction sources. : oracle accounts receivable

575


How would you determine what sessions are connected and what resources they are waiting for?

1612


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1492


WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2388


which gives Oracle R12 Financial training in delhi please give me answer its urgent?

1914


can we use lexical perameter in oracle plsql if yes how

1824


What is the difference between conversions and interfaces? : oracle accounts receivable

650


what is the link between suppliers and banks in ap module in oracle apps? And also query?

2013


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

16354


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.

1871