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
How remove data files before opening a database?
What is analyze command used for?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
Is there a combination of "like" and "in" in sql?
When do you get a .pll extension in oracle? Explain its importance
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??
What are the restrictions on external table columns?
How to open a cursor variable?
how do u setup a replication site?
Give syntax for SQL and ORACLE joins.
How will you differentiate between varchar & varchar2?
What do you know about normalization? Explain in detail?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How to define a sub function?