if i perform any operation on views such as insert, delete
etc will my base table get affected?????
Answer Posted / radha sri seshu.kolla
yes it will effect if your view is a simple view (eg:
create or replace view empview as select * from emp;) this
is called simple view. if you use any joins or if u create
view using more than two tables then it is called complex
view. in case of comlex view the database will not effect.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the 3 types of behavioral triggers?
What is materialized view in sql?
Why do we use set serveroutput on?
what is myisam? : Sql dba
What is tuple in sql?
What is difference between function and trigger?
how to increment dates by 1 in mysql? : Sql dba
What is the usage of distinct keyword?
What does cursor do in sql?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
Why do we use procedures?
Which normal form is best?
How does join work in sql?
what is the difference between union and union all? : Sql dba
how to select unique records from a table? : Sql dba