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
What are the uses of synonyms?
What is transport network substrate (tns) in oracle?
Why do we use coalesce function in oracle?
How to run create database statement?
What is the usage of merge statement?
How can we view last record added to a table?
How to export your connection information to a file?
How to build data dictionary view an new database?
In oracle there is column command, how will you explain that?
What are the restrictions on external table columns?
What is a read write transaction in oracle?
Explain what are the different type of segments?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
master table and child table performances and comparisons in Oracle ?
How to create a temporary table in oracle?
