Interested to Buy Any Domain ? << Click Here >> for more details...
If we update a complex view, is base table will get update ?
- 2 Answers
- 5274 Views
- Ardee Technologies, HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dinesh
Yes We can update base table through complex view
Using "Instead of trigger"
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / zeeshan
Yes one can update complex view where base table data will get affect but few constraint are there like view does not have group by ,order by , or N level function like Rank, dense Rank and Rownumer partition by etc
| Is This Answer Correct ? | 5 Yes | 1 No |
What are the different parts of a package?
Is join same as left join?
What are the basic techniques of indexing?
How to read xml file in oracle pl sql?
How to display all Friday's in a year with date?
How will you a activate/deactivate integrity constraints?
What are the types pl/sql code blocks?
How to get the procedure's, function's name from a package if it is wrapped(both spec & body).
What is set transaction?
What are literals in sql server?
write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000
Can triggers stop a dml statement from executing on a table?
-
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)
