Interested to Buy Any Domain ? << Click Here >> for more details...
If we update a complex view, is base table will get update ?
- 2 Answers
- 5421 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 is explain plan?
how can we find the number of rows in a table using mysql? : Sql dba
what happens if null values are involved in expressions? : Sql dba
What is sql injection vulnerability?
Does varchar need length?
What is the purpose of cursors in pl/sql?
If we update a complex view, is base table will get update ?
2 Answers Ardee Technologies, HCL,
How does one load ebcdic data? : aql loader
What is difference between stored function and application function?
What are the topics in pl sql?
table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.
Does db2 use 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)
