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
What is sql table?
Show code of a cursor for loop.
What is cross join sql?
Is it possible to read/write files to-and-from PL/SQL?
How many sql statements are used? Define them.
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
how do you know if your mysql server is alive? : Sql dba
What is a variable in sql?
What does := mean in pl sql?
What does pl sql developer do?
What is the usage of nvl function?
how many values can the set function of mysql take? : Sql dba
what is error ora-03113: end-of-file on communication channel?
How do I save the results of sql query in a file?
how to create a new view in mysql? : Sql dba