Interested to Buy Any Domain ? << Click Here >> for more details...
Can a view be updated/inserted/deleted?If Yes under what
conditions?
- 3 Answers
- 13929 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 |
Can we use ddl statements in stored procedure?
what is outer join? what is selef join? what is difference between them? what is cartecion join?
1 Answers Fiserv, Herbinger, Synechron,
Which sql statement is used to delete data from a database?
What is the difference between delete, truncate and drop command?
How can you load microsoft excel data into oracle? : aql loader
How to create a view on a table which does not exists
What is an Integrity Constraint?
Which is better join or subquery?
How do you respond to dementia behavior?
Why stored procedures are faster than query?
what's the difference between a primary key and a unique key? : Sql dba
Can we join 3 tables 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)
