If a View on a single base table is manipulated will the
changes be reflected on the base table?
- 5 Answers
- 13540 Views
- I also Faced
- E-Mail Answers
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
What is structural independence and why is it important?
tell us something about heap tables. : Sql dba
How do you write a subquery?
What type of join is sql join?
what are the differences between char and varchar? : Sql dba
What do you mean by field in sql?
What are instead of triggers?
Which are sql * plus commands?
Why is a trigger used?
Is sql an operating system?
What is primary key in db?
What is memory optimized?
How many types of cursors are available in pl/sql?
What are primary key and foreign key and how they work?
What is an exception in pl/sql?
