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
How many sql core licenses do I need?
What is embedded sql what are its advantages?
What is numeric function sql?
How will you distinguish a global variable with a local variable in pl/sql?
Does execute immediate commit?
What is an escape character in sql?
Is subquery faster than join?
What is trigger explain it?
When you have to use a default "rollback to" savepoint of plvlog?
Describe sql comments?
What is record variable?
Can we use threading in pl/sql?
Is crud a cuss word?
Is big data nosql?
Why truncate is used in sql?