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
- 10824 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 $$ in sql?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Explain what is an index?
tell me about various levels of constraint. : Sql dba
What are aggregate functions in sql?
Is it possible to create the following trigger: before or after update trigger for each row?
Which is faster view or stored procedure?
Can we call stored procedure in function?
How to pipe multiline string to isql?
What is data types in sql?
Why join is faster than subquery?
What programs use sql?
What is sorting in sql?
What is full join?
how do you login to mysql using unix shell? : Sql dba
