Answer / guest

A View can be updated/deleted/inserted if it has only one
base table if the view is based on columns from one or
more tables then insert, update and delete is not possible.

Answer / anurag

Also with the help of instead of trigger we can update the
view

Answer / swapnareddy

A View can be updated/deleted/inserted if it has only one
base table if the view is based on columns from one or
more tables then insert, update and delete is possible with
thehelp of instead of trigger.

How to get the 3rd column(i.e all the data along with the column name)in a table?

2 Answers   Logica CMG,

---

what is meant by DML?

5 Answers   HCL,

---

What is the most restrictive isolation level? : Transact sql

0 Answers  

---

Is a foreign key always unique?

0 Answers  

---

how can we know the number of days between two given dates using mysql? : Sql dba

0 Answers  

---

What is nosql example?

0 Answers  

---

Why is sql better than hql?

0 Answers  

---

How are sql commands classified?

0 Answers  

---

I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.

1 Answers  

---

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,

---

How global cursor can be declare with dynamic trigger ?

0 Answers  

---

Can we call dml statement in function?

0 Answers  

---