Can a view be updated/inserted/deleted?If Yes under what
conditions?
- 3 Answers
- 13241 Views
- I also Faced
- E-Mail Answers
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
What are the advantages of normalization?
How does rowid help in running a query faster?
Explain two easy sql optimizations.
What is nested table in pl sql?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is sap sql?
What are system versioned tables?
What is sql partition function?
Write a sql query to find the names of employees that begin with ‘a’?
What is a full join sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
what is meant by nl2br()? : Sql dba
what is the difference difference between procedure and packages
What are the most important characteristics of pl/sql?
What programs use sql?
