Can a view be updated/inserted/deleted?If Yes under what
conditions?
- 3 Answers
- 12729 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 parts of a basic sql query?
i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6
Talk about views
What is pivot query?
What is the source code of a program?
is mysql query is case sensitive? : Sql dba
Is primary key always clustered index?
What are the uses of sysdate and user keywords?
What is sql mysql pl sql oracle?
Is it mandatory for the primary key to be given a value when a new record is inserted?
How to write a query to show the details of a student from students table whose
How do you take the union of two tables in sql?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
