If a View on a single base table is manipulated will the
changes be reflected on the base table?
Answers were Sorted based on User's Feedback
Answer / ehsraka
Yes, definitely. Since the view is based on a single table
and falls within the cateogory of simple view. Any change /
modification on the records will be reflected in the base
table.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / aks
Depends on privileges granted to view (select,insert,update);
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / 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 |
Answer / papal
yes if there is no use of "CHECK WITH option"
then definitally chnages in view affects the base table
Is This Answer Correct ? | 3 Yes | 1 No |
Can I learn sql in a week?
If we update a complex view, is base table will get update ?
2 Answers Ardee Technologies, HCL,
What is sql*loader and what is it used for? : aql loader
Where is pl sql used?
if we give update table_name set column_name= default. what will happen?
What is varchar data type in sql?
difference between table level constraint and column level and advantages of table level constraint
pl/sql testing means what ...... explain process how to find pl/sql bugs
will function return more than one value how
what are all different types of collation sensitivity? : Sql dba
What are sql constraints?
which tcp/ip port does sql server run on? : Sql dba