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
- 10784 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 left join and right join?
How sql query is executed?
Can we use ddl commands in pl sql?
Will truncate release space?
What are primary key and foreign key and how they work?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Define union, minus, union all, intersect ?
Explain clause in sql?
What is the difference between in and between in sql?
How can we find duplicate records in a table?
What is procedure and function in sql?
What is serial sql?
what tools available for managing mysql server? : Sql dba
how to see the create table statement of an existing table? : Sql dba
What is sql catalog?
