Answer Posted / agrawalamit166
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 is
possible only when all not null values will be included in
the query. means we can insert values in multiple tables
with the help of view if we take all not null field at the
time view creation.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between oracle's plus (+) notation and ansi join notation?
What is ordinary table in oracle?
How much memory your 10g xe server is using?
When do you get a .pll extension in oracle?
How to create an oracle database?
How to run create database statement again?
What is object data modeling?
Explain a synonym?
What is an oracle tablespace?
What are the original export and import utilities?
How do I manually create a database in oracle?
How to commit the current transaction in oracle?
Explain the use of grant option in exp command.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Is oracle a language?