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 |
What are the different ddl commands in sql?
What is a sql*loader control file?
Can you selectively load only those records that you need? : aql loader
how u can find the n row from a table?
What is execute immediate?
How to fetch records from a partitioned table?
what is the difference between a local and a global temporary table? : Sql dba
How can we store rows in PL/SQL using array?
How do I copy a table in sql?
What are the different tcl commands in sql?
What are database links used for?
how many values can the set function of mysql take? : Sql dba