Interested to Buy Any Domain ? << Click Here >> for more details...
Can a view be updated/inserted/deleted?If Yes under what
conditions?
- 3 Answers
- 13935 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / anurag
Also with the help of instead of trigger we can update the
view
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / swapnareddy
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 possible with
thehelp of instead of trigger.
| Is This Answer Correct ? | 5 Yes | 2 No |
What is not null in sql?
What is the Diff b/w Constraints and Trigeer
Its possible to add more than one primary key for the table
What are tables and fields?
What is bulk collect in pl sql?
What does where 1 1 mean in sql?
How do I view an execution plan in sql?
What are the qualities of 2nf?
How many functions are there in sql?
Why do we use triggers?
what is the difference between granting and creating a view?
Which is the correct statement about truncate and delete?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
