Answer Posted / manoj
This is a virtual table do not have physical existence
only at run time it retrive valves from one or more than
one tables.
opertion: insert , update , delete
case 1:- If view created on only one table than DML
can perform on that TABLE
case 2:- If view Made on more than one then DML cant
possiple
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a procedure 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.
Explain the use of file option in exp command.
How to create a testing table in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Who developed oracle & when?
Does facebook use oracle?
How to convert characters to times in oracle?
What is a initialization parameter file in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to enter a new row into a table interactively?
How to assign values to variables?
How to call a stored function with parameters?
What is Reduced List of Values?