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 ?
1548plz send all placement /aptitude question paper of sbi bank foe clerical recruitment today only.
3 5585send state bank of india clerical exam test papers questions and answers in all subject to vijeesh_tv@yahoo.com
9 12249plz send me last 5 years solved question paper of sbi clerk post on my yahoo id.my yahoo id is my id is s_athare@yahoo.com
13 14281Please send me on copy for SBI CLERCKICAL EXAM MODEL PAPERS IN MY MAIL ID: rasirajubaskhar@yahoo.com.
1 3519
Write any four activities that can be given as composition work.
where still you go?
Rail road aptitude test questions or called TDAT. Need help in trying to get a heads up on the questions asked on the TDAT.
Dear friends, Can anybody say preparation method and best coaching centre for ias?? sridhar patro
how to clearify and solve the english comprehensive questions?
what are your areas of strengths
Problems on Trains, Time and Distance, Problems on Numbers, Calendar
WHY AND WHERE RTGS TO BE USED.
what is filtration??? what is decantation??? what will be the difference between the products of filtration and decantation???
hi sir i am doing b.e final year computerscience i want merittracks model question paper pls send link for all merittraks question paper..
Differentiate between content and structural words.
please send some sample or previous papers of karur vysya bank engineering recruitment
plz send me eng apti ques and sbi clarical ques plz... bikranz4u@yahoo.com
I have done with my engineering and i'm looking forward to prepare for civils.I've heard R C reddy is the best coaching centre in hyderabad for civils but are they any batches for civils coaching in R C reddy like other s/w coaching centres. please let me know about dat.
Com pany C sells a line of 25 products with an average retail price of $1,200. If none of these products sells for less than $420, and exactly 10 of the products sell for less than $1,000, what is the greatest possible selling price of the most expensive product
