Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to create a new tablespace in oracle?
How to rename a tablespace in oracle?
How to create a table in a specific tablespace?
How to insert a record into a table?
How to convert character types to numeric types?
How to create id with auto_increment on oracle?
What is an oracle table?
What is an oracle and why it is used?
How would you begin to troubleshoot an ORA-3113 error?
How to get a list of all user accounts in the database?
What is using clause and give example?
what are archived logs?
Explain oracle 12c new features for developers?
Explain integrity constraints?
How to turn on or off recycle bin for the instance?
