can a view be updated?

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


Please Help Members By Posting Answers For Below Questions

How do I know if oracle is installed on windows?

480


What is oracle datasource?

540


Can you create a synonym without having a table?

543


How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1429


What is the difference between translate and replace?

546






Explain the importance of .pll extension in oracle?

546


How to count duplicated values in a column in oracle?

542


How to select an oracle system id (sid)?

575


Explain the features of oracle?

588


How to retrieve the count of updated rows?

568


What are data pump export and import modes?

602


How to create a stored program unit?

567


State and explain the different types of data models?

525


What is data type in oracle?

556


How to initialize variables with default values?

621