Interested to Buy Any Domain ? << Click Here >> for more details...
if i perform any operation on views such as insert, delete
etc will my base table get affected?????
- 4 Answers
- 10607 Views
- I also Faced
- E-Mail Answers
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
when MSQL8.0 is in market
Can we use ddl statements in stored procedure sql server?
What is sql mysql pl sql oracle?
what is schema? : Sql dba
which tcp/ip port does sql server run on? : Sql dba
Can we group by two columns in sql?
Mention what is the use of function "module procedure" in pl/sql?
What is sql used for?
What is difference between hql and sql?
In pl/sql, what is bulk binding, and when/how would it help performance?
What is a full join sql?
What is a pl/sql block?
Is left join faster than inner join?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
How many types of keys are there in sql?
