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 do I uninstall oracle 11g?
How to set up autotrace for a user account?
What do you mean by cdb and pdb in oracle 12c?
Whether any commands are used for months calculation? If so, what are they?
How to compare dates in oracle sql?
How to insert multiple rows with one insert statement in oracle?
What is a subquery in oracle?
What is the usage of synonyms?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
what is the use of system.effective.date variable in oracle?
What are named parameters?
How to write a query with a left outer join in oracle?
What are the built-in functions used for sending Parameters to forms ?
How can I combine multiple rows into a comma-delimited list in oracle?