Answer Posted / kumar
View can be updated ...but some restrictions are there.
Let us think we are using one or more tables to create a
view and if the view contains all the NOT NULL constraint
columns of the tables, then only we can update the view or
else we can't.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Please explain oracle left join with an example?
Write a trigger example in oracle?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to run the anonymous block again?
How to create a new view in oracle?
How to execute the package in oracle?
What are the different types of modules in oracle forms?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Can we connect to ORACLE db using Windows Authentication?
how to join query for one source type is oracle another source type is sql server ?
Is a rollback possible to any savepoint?
How to return top 5 rows in oracle?
Explain do view contain data?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
please explain.. DB architecture ...