If a View on a single base table is manipulated will the
changes be reflected on the base table?
Answer Posted / 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 |
Post New Answer View All Answers
Is sql database free?
What is rownum in sql?
What is mutating error?
Which are sql * plus commands?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
How do I create a sql database?
What are the benefits of pl sql?
What plvcmt and plvrb does in pl/sql?
What is a sql profiler?
what is heap table? : Sql dba
What is nvl?
What is the difference between rollback and rollback to statements?
how can we repair a mysql table? : Sql dba
Is pl sql better than sql?
What is a system versioned table?