Can a view be updated/inserted/deleted?If Yes under what
conditions?
Answer Posted / guest
A View can be updated/deleted/inserted if it has only one
base table if the view is based on columns from one or
more tables then insert, update and delete is not possible.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Show code of a cursor for loop.
Does truncate require commit?
How do I run a query in pl sql developer?
Can you have more than one key in a database?
how do you login to mysql using unix shell? : Sql dba
What do you know by pl/sql cursors?
What is sqlerrm?
what are all types of user defined functions? : Sql dba
explain the advantages and disadvantages of stored procedure? : Sql dba
Why do we need cursors in pl sql?
Explain isolation levels. : Transact sql
Can we debug stored procedure?
How many types of relationship are there?
What is the use of sql trace?
Can sql function call stored procedure?