if i perform any operation on views such as insert, delete
etc will my base table get affected?????
Answer Posted / gourvendra singh
It will affect ur base table only when u having a simple
view and if you put null in the field which is primary key
of the base table then also the base table will not
affected. And if you are using the compute view then u r nt
able to insert or delete the records.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Why do we go for stored procedures?
Why do we need cursor in pl sql?
what are date and time data types in mysql? : Sql dba
What is view explain with example?
What is database migration?
What is having clause in sql?
How do I order by ascending in sql?
Why is pl sql used?
what is a primary key? : Sql dba
what is the difference between primary key and unique key? : Sql dba
What is the left table in sql?
What is a call statement? Explain with an example.
Why we use joins in sql?
What are sql ddl commands?
how to rename an existing table in mysql? : Sql dba