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.

i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 Answers  

---

How can you select unique records from a table?

0 Answers  

---

What is rownum and rowid?

0 Answers  

---

What is rank function in sql?

0 Answers  

---

what is External tables? explain with examples

2 Answers   TCS,

---

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

How to get employee name from employee table which is the fiveth highest salary of the table

20 Answers   Infosys, Rolta,

---

tell me about various levels of constraint. : Sql dba

0 Answers  

---

Can you join a table to itself?

0 Answers  

---

What is NOCOPY?

6 Answers   DELL,

---

List the different type of joins?

0 Answers  

---