Repetaed Questions like 1)finding the unrepeated from 2n-1
nos and 2)finding duplicate no 3)better datastructure for
paranthesisi elimination?
what is html
SSC ? Grade ?D? Exam ENGLISH CLOSET TEST TEST ? 1
How to decrease High Utilizatoin On Cisco 2800 seriase Router ?
What is critical pedagogy?
0 Answers Mahatma Gandhi University,
hows your last weekend?
how disable usb device in group policy editor all configure tell me early
SSC ? Grade ?D? Exam ENGLISH CLOSET TEST, TEST ? 13
When was Buddha born
what are jargons?
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 ?
If a:b=5:6 and b:c=5:6, a:c=? a)5:6 b)36:25 c)25:27 d)38:40
why are you want join army?