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
List the various oracle database objects?
How to define an anonymous procedure with variables?
What are triggers in oracle?
How to convert a string to a date in oracle database?
What are the different types of database objects?
How to check your oracle database 10g xe installation?
What is the string concatenation operator in oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
How to import one table back from a dump file?
Explain the use of ignore option in imp command.
What is a trigger and what are its types in oracle?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is memory advisor in Oracle?
What is Trigger in Oracle?
