Interested to Buy Any Domain ? << Click Here >> for more details...
If we update a complex view, is base table will get update ?
- 2 Answers
- 5415 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 |
table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0
What are the sql commands?
What is the difference between left and left outer join?
What is a rank in sql?
How many types of privileges are available in sql?
How to run sql statements through the web interface?
Can a foreign key be null?
Can we create view in stored procedure?
Explain mutating table error.
Differentiate between % rowtype and type record.
What is the Query to print out the individual total number of duplicate row in sql.
what is acid property in database? : Sql dba
-
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)
