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 does inner join mean?
Is sql a scripting language?
What is a left inner join?
What are the syntax and use of the coalesce function?
Is pl sql different from sql?
What is partition by in sql?
What is the difference between local variables and global variables?
what is 'trigger' in sql? : Sql dba
What is the difference between sql and t sql?
What are data types in pl sql?
Explain about various levels of constraint.
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is a left join?
Give the order of sql select?
How many types of cursors supported in pl/sql?