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
defination of bitmap index
What is a tns file?
How to change system global area (sga) in oracle?
How to start a new transaction in oracle?
What are the different types of database objects?
Is there any function in oracle similar like group_concat of mysql?
what is the difference between restoring and recovering?
What is null value in oracle?
How to use subqueries with the in operator using oracle?
Which are the five query types available in oracle?
What is connection pooling in oracle?
What is transaction control statement and how many types of transaction control statement in Oracle?
Can sub procedure/function be called recursively?
Explain the use of record option in exp command.
Is rowid unique in oracle?
