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
What is data type in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is different types of joins?
How to execute the package in oracle?
What are the common oracle dba tasks?
Explain the difference between a procedure and a function?
How to delete a user account in oracle?
How to start an oracle instance?
How does the on-delete-cascade statement work?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Explain the use of rows option in exp command.
How to execute a stored program unit?
How to estimate disk space needed for an export job?
What is the minimum client footprint required to connect c# to an oracle database?