if you update view? where we store the data?
- 5 Answers
- 9383 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / vishal muthal
View is nothing but the virtual table made from few columns
of the base table to get faster retrival and fetch of the
data. Hence when you update any view the column which you
updating is get updated,and the column basically belongs to
the base table.hence answer is IT WILL UPDATE BASE TABLE
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to check the server version in oracle?
What is hot backup and logical backup?
How to get execution path reports on query statements?
What is merge statement used for?
What do you mean by redo log file mirroring?
Does facebook use oracle?
What are the different types of modules in oracle forms?
Explain an exception?
How to invoke the data pump import utility?
How to increment dates by 1 in oracle?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
How can we find out the current date and time in oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to revoke create session privilege from a user in oracle?
Explain drop constraint oracle?
