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  

---

Please send me the last 3 years question papers of State Bank of India clerical exmas, my email chanu613@gmail.com,

2 Answers  

---

what types of question asked in english section

0 Answers   EON IT Park, TATA, Tata Communications, TCS,

---

Two of Telugu - bier The poetry is written in:-

0 Answers  

---

which is OPPOSITE in the meaning of the given word INDISCREET.

6 Answers   Emphasis, JPMorgan Chase,

---

SSC ? Grade ?D? Exam ENGLISH CLOSET TEST TEST ? 27

1 Answers  

---

What is the opposite of essential

17 Answers  

---

difference between drug purity and drug potency

0 Answers  

---

how to sell a refrigerator to eskimo

3 Answers   TATA, Tata Steel Limited,

---

SSC ? Grade ?D? Exam ENGLISH CLOSET TEST TEST ? 31

1 Answers   Wipro,

---

the name given to the border which separates pakistan and hindustan is

1 Answers  

---

Can you please mail me the frequently asked model in Railway Recruit ment Board with answers?

0 Answers  

---