Interested to Buy Any Domain ? << Click Here >> for more details...
If we update a complex view, is base table will get update ?
- 2 Answers
- 5312 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 |
Can procedure in package be overloaded?
What is optimistic concurrency control? : Transact sql
Does user triggers have entry for trigger with compilation errors?
What are sql queries used for?
How delete all data from table in sql?
How to get the procedure's, function's name from a package if it is wrapped(both spec & body).
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is sql mysql pl sql oracle?
Why do we need pl sql?
Is a foreign key always unique?
Explain correlated query work?
What does seeding a database mean?
-
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)
