Answer Posted / yogesh babu
yes it can be updated ....but there are certain
restrictions in it.
For eg:
1.a view created from nonupdatable view cant be updated
2.when it is having having , groupby,orderby it cant be
updated.etc
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How to update values in a table in oracle?
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.
How to check the server version in oracle?
What is the quickest way to export a table to a flat file?
What is the difference between Delete, Truncate and Drop in Oracle?
what's query optimization and without use of IN AND Exist can we get another way data from query
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Explain the use of indexes option in imp command.
What do you mean by cdb and pdb in oracle 12c?
Does oracle database need java?
How to use "if" statements on multiple conditions?
what is IDE,DMV in sql server?
What does sharding mean?
How to best split csv strings in oracle 9i?
Which environment variables are absolutely critical in order to run the OUI?