SQL> desc product1; Name Null? Type ----------------------------------------- -------- ---------------------------- PROD_ID NOT NULL NUMBER(38) PROD_QTY NUMBER(38) SQL> select * from product1; PROD_ID PROD_QTY ---------- ---------- 123 300 124 200 SQL> desc pmsales; Name Null? Type ----------------------------------------- -------- ---------------------------- PROD_ID NOT NULL NUMBER(38) PMS_QTY NUMBER(38) SQL> select * from pmsales; PROD_ID PMS_QTY ---------- ---------- 123 100 124 200 SQL> create view pmas_prod 2 as select p.prod_id,p.prod_qty,pm.pms_qty 3 from product1 p,pmsales pm 4 where p.prod_id=pm.prod_id; View created. SQL> update pmas_prod 2 set prod_qty=prod_qty-pms_qty; 2 rows updated. SQL> select * from product1; PROD_ID PROD_QTY ---------- ---------- 123 200 124 0 SQL> insert into pmas_prod values(125,400,200); insert into pmas_prod values(125,400,200) * ERROR at line 1: ORA-01776: cannot modify more than one base table through a join view Q How can we insert into this table ?

0 Answers  

---

WHAT IS UPS

2 Answers   HCL, ups,

---

Hi I am nitin, i am preparing for Junior Court Assistant exam for supreme court, so I want previous question paper related with General English questions,General Aptitude questions and General Knowledge questions. My email id is nitinpal288@gmail.com Thanks in advance.

0 Answers  

---

please send me the apptitude questions for ongc exam

0 Answers   IBM,

---

what is the origin place of english language?

5 Answers  

---

---

Discuss the relevance of constructivism in the context of the new curriculum frameworks.

0 Answers   Mahatma Gandhi University,

---

When u loved someone and he/she is trying to throw a grenade in crowed place. What you will do ? you will kill him/her ? For this sentence we need to write an essay altest 1 page. Please help me in this by posting the answers to sruthi_53@yahoo.co.in

0 Answers  

---

what would be the appropriate answer about our hobby if we have not any particular hobby?

2 Answers  

---

which type of paragrph questions and answers me 24/7

0 Answers  

---

I want english aptitude SBI model question paper

2 Answers   State Bank Of India SBI,

---

i need section engineer previous question papers.if anybody have it plzzz send to my email id :prad60@gmail.com

0 Answers   RRB,

---

Rich man needs it The poor man has it If you eat it, you will die...

11 Answers   Infosys, Lanco, Sri Chaitanya,

---