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 do you tell what your machine name is and what is its IP address?
Differentiate between post-database commit and post-form commit?
What is a data lock in oracle?
What is raw datatype in oracle?
Explain temporal data types in oracle
What is Library Cache in Oracle?
What are the various types of snapshots ?
Explain self joins in oracle?
In oracle there is column command, how will you explain that?
How to test null values?
Why does oracle 9i treat an empty string as null?
How to assign a tablespace to a users in oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
definition of cluster and non-clustered index?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?