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
Which is faster join or subquery in oracle?
What are advantages of dateset in datastage?
Name the various constraints used in oracle?
How to export data with a field delimiter?
Explain the dml?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is meant by raw datatype?
In what script is snap$ created? In what script is the scott/tiger schema created?
How to use group functions in the select clause using oracle?
What is an Oracle index?
what happened to the global index when I truncate the data in one of the partition?
How to drop an existing table in oracle?
How to filter out duplications in the returning rows using oracle?
What is bulk collect in oracle?
What is a cursor and what are the steps need to be taken?
