if i perform any operation on views such as insert, delete
etc will my base table get affected?????
- 4 Answers
- 9966 Views
- I also Faced
- E-Mail Answers
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 informix sql?
Can we use ddl statements in stored procedure sql server?
What is before trigger?
How do sql triggers work?
What is the use of desc in sql?
Is sql better than access?
What is parallel hint?
What are the advantages of normalization?
What is server name sql?
What is clustered index in sql?
I need a function for a train ticket reservation please answer it thanks in advance
What is scalar function in sql?
What are pl sql data types?
what is the difference between inner and outer join? Explain with example. : Sql dba
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
