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 to connect to oracle using service name instead of sid?
How to do paging with oracle?
Is oracle a relational database?
How to use an explicit cursor without open statements?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is an oracle database table?
How to call a stored function with parameters?
What is the difference between postgresql and oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What are the different types of trigger and explain its various uses and functions?
What is oracle open database communication (odbc)?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Is primary key indexed by default in oracle?
What are the numeric comparison operations?
Where do we use decode and case statements?