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 ?
1921plz send all placement /aptitude question paper of sbi bank foe clerical recruitment today only.
3 6946send state bank of india clerical exam test papers questions and answers in all subject to vijeesh_tv@yahoo.com
9 14651plz 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 17688Please send me on copy for SBI CLERCKICAL EXAM MODEL PAPERS IN MY MAIL ID: rasirajubaskhar@yahoo.com.
1 4206
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
full detail for antisurgevalve how to work?
how to clearify and solve the english comprehensive questions?
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.
sir please send me last 5 years solved question paper of junior engineer track machine of electronics & communication engineering branch
What is the Water offline conductivity
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
Suggest measures to improve the speaking skill of students
sir,plz tell what topics cover under managerial aptitude for officer under trainee general(APSRTC) recruitment.plz send to my mail-id. My mail-id z:kvsurendra.kumar@gmail.com
what has given you the greatest sense of accomplishment in life
hi my bank of baroda written test will held on 13th march so let me know all appti question also mths question pls send me queston with answer my mail id is amrapalimohite@yahoo.com
what is meant by syntax?
hi, please give down link for E book of objective English by RS Agarwal and vikas agarwal at my Email id -- barun561@gmail.com
Mention any two principles of behaviourism with regard to language learning.
my tds deduction is 654 per month,then how much investment i hve to show ?
