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 ?
1972plz send all placement /aptitude question paper of sbi bank foe clerical recruitment today only.
3 7124send state bank of india clerical exam test papers questions and answers in all subject to vijeesh_tv@yahoo.com
9 15014plz 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 18198Please send me on copy for SBI CLERCKICAL EXAM MODEL PAPERS IN MY MAIL ID: rasirajubaskhar@yahoo.com.
1 4315
When u loved someone and he/she is trying to throw a grenade in crowed place. What you will do ? you will kill him/her ? For this sentence we need to write an essay altest 1 page. Please help me in this by posting the answers to sruthi_53@yahoo.co.in
are mnc good for developing country? and why?
please send me the apptitude questions for ongc exam
in 25 words explain what you understand to be the difference between administrative [immigration] detention and correctional imprisonment.
why do used bucolzh relay in 1000kva transformer
Sir,plz tell me what topics to prepare for the mangerial aptitude for office under trianee general exam.sir,plz send me as soon as possible 2 my mail-id.My id z:rayudu.lph@gmail.com
Logical appitude
on c,c++.core java
linux advantages and important questions &anwers
What is compounding infoobjects?
vertical measure
contractor have done the work with out any information and blamed me that they got permission from my side. Now how do i write a letter to my boss against contractor
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 ?
Explain the nature and characteristics of language.
I sudhakar i applied for the post of AAI jr. executive ( Electronics) written exam on october. I want to know the syllabus and pattern of the exam in the AAI site there is no information on syllabi......so, please be patient and forward me the syllabus for the exam my friends....... I will be very much thankful to you. my email mailid- ecsudhakar@gmail.com
