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 GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
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
What is the difference between the SQL*Loader and IMPORT utilities?
How do you use trigger to create mutating state of table
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
What is the mandatory setup in cyclecount ?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
Can we modify approve purchase order?if yes what is navigation?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.