If a View on a single base table is manipulated will the
changes be reflected on the base table?
Answer Posted / naresh
Hi
Not only on a single based table, changes made on a view
which created on multiple tables also will update on base
tables,if the relation ship between primary key and Foreign
key relationships are proper and if the Integrity
constraints are mentioned.
Cheers!
Naresh
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Why plvtab is considered as the easiest way to access the pl/sql table?
How can I tell if sql is running?
Is sql developer case sensitive?
What are three advantages to using sql?
how to enter characters as hex numbers? : Sql dba
What is data control language?
What is latest version of sql?
Does execute immediate commit?
Name the operator which is used in the query for pattern matching?
Does sql require a server?
What is the difference between clustered and non-clustered indexes?
Why we use stored procedure instead of query?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
what does myisamchk do? : Sql dba
what are the advantages a stored procedure? : Sql dba