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 is the difference between inner join and left join?
What is difference between sql and mysql?
While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?
What is partition in sql query?
Does sql require a server?
difference between cursor and procedure in a package
Can we insert data into materialized view?
What is sql not null constraint?
State the advatage and disadvantage of Cursor's?
What is the sql*loader? : aql loader
how do you know if your mysql server is alive? : Sql dba
How do I edit a stored procedure?