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
How do I quit sql?
Explain cursor types?
What is varray in pl sql?
Write a query to display the current date in sql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is cascade in sql?
Is left join same as inner join?
Explain mutating table error.
Explain unique key in sql.
what is the difference between delete and truncate commands? : Sql dba
What is the purpose of my sql?
Can you skip header records while loading? : aql loader
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
How long it takes to learn pl sql?
explain what is mysql? : Sql dba