if i perform any operation on views such as insert, delete
etc will my base table get affected?????
- 4 Answers
- 9967 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
what is the difference between nested subquery and correlated subquery?
What is nosql db?
What is procedure and function in sql?
How do you rank data in sql?
how to drop an existing table in mysql? : Sql dba
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
Does a join table need a primary key?
What is sql entity?
What are the built in functions of sql?
what is bcp? When is it used?
how to convert dates to character strings? : Sql dba
What is union and union all keyword in sql and what are their differences?
What are the subsets of sql?
How do I order columns in sql?
What are the triggers associated with image items?
