Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
1974plz send all placement /aptitude question paper of sbi bank foe clerical recruitment today only.
3 7129send state bank of india clerical exam test papers questions and answers in all subject to vijeesh_tv@yahoo.com
9 15026plz 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 18215Please send me on copy for SBI CLERCKICAL EXAM MODEL PAPERS IN MY MAIL ID: rasirajubaskhar@yahoo.com.
1 4320
why the Peak shape is in opposite direction in IR ?
write code for calculating Standard Deviation in c sharp
What is the average of x, y, and z? 1. 2x + y + 4z = 23 2. 3x + 4y + z = 22 statement 2 alone is sufficient, but statement 1 alone is not sufficient to answer the question both statements taken together are sufficient to answer the question, but neither statement alone is sufficient statement 1 alone is sufficient, but statement 2 alone is not sufficient to answer the question statements 1 and 2 together are not sufficient, and additional data is needed to answer the question
Suggest any two synthetic methods of teaching reading.
tell me about your create own plan.
what is filtration??? what is decantation??? what will be the difference between the products of filtration and decantation???
what has given you the greatest sense of accomplishment in life
vertical measure
I have passed in repco bank officer scale 1.what type of interview question they may ask? pls send ur ideas to my email id nabanbadma@yahoo.co.in
Write any four activities that can be given as composition work.
The total weight of a tin and the cookies it contains is 2 pounds after some of the cookies are eaten, the tin and there remaining cookies weigh 0.8 pounds. What is the weight of the empty tin in pounds ?
How to decrease High Utilizatoin On Cisco 2800 seriase Router ?
you have to establish a cosmetic industry in India & how you would like to expand in the middle east ?what role of culture will be there in your HR practices n also highlight an employee management issue you would face n give remedies as to now would you tackle those issues.
Give two activities for improving the skill of speaking.
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
