Interested to Buy Any Domain ? << Click Here >> for more details...
If we update a complex view, is base table will get update ?
- 2 Answers
- 5416 Views
- Ardee Technologies, HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the uses of database trigger.
how to rename an existing column in a table? : Sql dba
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What are different functions in sql?
What is the difference between database trigger and stored procedure?
What is dynamic sql in pl sql?
What are the different ways to optimize a sql query?
What is the meaning of disabling a trigger?
Is progress software supports to ( pl/sql )?
Does truncate require commit?
Why sql query is slow?
What does the argument [or replace] do?
explain advantages of myisam over innodb? : Sql dba
What are sql built in functions?
Is it possible to link two groups inside a cross products after the cross products group has been created?
