can we update a view which is created from two tables
Answer Posted / raj
folks, I check in practically that View (consist of more
then one table) can update and it impact at Base Table also.
(you can also check from your own self...)
but I data cannot delete from view.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is program debugging?
how to start mysql server? : Sql dba
How do you create a db file?
What are different types of sql?
What is embedded sql with example?
Explain the purpose of %type and %rowtype data types with the example?
Is sql similar to python?
how to enter numeric values as hex numbers? : Sql dba
What is the difference between instead of trigger and after trigger?
What does desc stand for?
What is loop in pl sql?
what is innodb? : Sql dba
What is java sql package?
how to drop an existing view in mysql? : Sql dba
How do you optimize a query?