Wade had 150 hits last season.He had 105 singles, 34
doubles, 1 triple and 10 home runs. What percent pf his
hits were single?
Answers were Sorted based on User's Feedback
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 ?
Write any two linguistic principles of language learning.
0 Answers Mahatma Gandhi University,
When you see a cell with a green triangle in the left top corner, what does this siginfy?
information about establishement of company.who is the founder of company.
who is the barnd ambasoder of rajsthan bank
3 Answers State Bank Of India SBI,
tell mee sume thing about ur self
22 Answers IBM, Satyam, Tech Mahindra, Wipro,
what is bank reconciliation statement?
all model paper of RRB examination of assistant station master of secunderabad
please give me idea about which type of ques are asked in jspl
can i get question papers 4 sbi po posts?
sir please send me last 5 years solved question paper of junior engineer track machine of electronics & communication engineering branch
Can anyone help on hpcl aptitude test.