Interested to Buy Any Domain ? << Click Here >> for more details...
Can a view be updated/inserted/deleted?If Yes under what
conditions?
- 3 Answers
- 13826 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 are the two characteristics of a primary key?
What is on delete restrict?
What is difference between % ROWTYPE and TYPE RECORD ?
How do I debug a stored procedure?
How can you fetch first 5 characters of the string?
Explain the uses of database trigger.
How can you load microsoft excel data into oracle? : aql loader
What are the main features of cursor?
What is oracle sql called?
How do I make sql search faster?
What is a database trigger?
How many tables can you join in sql?
-
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)
