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  

---

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

0 Answers  

---

Repetaed Questions like 1)finding the unrepeated from 2n-1 nos and 2)finding duplicate no 3)better datastructure for paranthesisi elimination?

1 Answers   Yahoo,

---

i MATHI PREPARING FOR BANK EXAMS PLEASE SEND ME A MODEL QUESTION PAPER FOR MY PREPARATION. WITH KIND REGARDS MATHI

1 Answers  

---

general hr question so asking for interview time company please sir request

0 Answers   Wells Fargo,

---

SSC ? Grade ?D? Exam ENGLISH CLOSET TEST TEST-9

1 Answers  

---

If a  person watch one  movie in a year and his age is 24 so what in this month he watched Before I Disappear movie online megashare so till now how many movies he watched. 

2 Answers  

---

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

1 Answers   SGS,

---

Differentiate between skimming and scanning.

0 Answers   Mahatma Gandhi University,

---

i want english language questions for bank exams and send questions to my mail id ssrinivasreddynew@gmail.com

1 Answers  

---

dear sir, i want last 5yrs question papers of clerical exam of sbi

0 Answers   Banking, Inscripts,

---

Can you please send me the exam pattern and questions for NIC Exam of previouus years to ashishgauba1985@yahoo.co.in

1 Answers  

---