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
- 10953 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 are the built in functions of sql?
How do I create a sql database?
How do you write an inner join query?
How to write pl sql program in mysql command prompt?
Can we delete column in sql?
How can you get sql*loader to commit only at the end of the load file? : aql loader
What are the advantages of stored procedure?
What is pivot table in sql?
How can we avoid duplicating records in a query?
How can I delete duplicate rows?
What is materialized view. What are different methods of refresh?
how to show all tables with 'mysql'? : Sql dba
What is primary and foreign key?
What is left join in postgresql?
What is prepared statement in sql?
