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
What is materialized view in sql?
Why are sql stored procedures used?
How can get second highest salary in sql?
explain the advantages and disadvantages of stored procedure? : Sql dba
Is join same as left join?
What is pl sql collection?
How to convert comma separated string to array in pl/sql?
What is percent sign in sql?
How are sql commands classified?
What is faster join or subquery?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What do you think about pl/sql?
how to drop an existing view in mysql? : Sql dba
Where the sql database files are stored?
what is timestamp in mysql? : Sql dba