If we update a complex view, is base table will get update ?
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 |
display your age in months?
How do you respond to dementia behavior?
what is oracle sql,pl/sql with interfaces
what is the difference between truncate and delete statement? : Transact sql
What is sql integrity?
What are pl/sql packages?
What are the parameter modes supported by pl/sql?
How do you change a value in sql?
What does inner join mean?
What is the usage of NVL?
7 Answers Infosys, Micro Infotek,
is mysql query is case sensitive? : Sql dba
Maximum how many triggers can we use in trigger and How to find out how many records it fetched.
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)