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 ?

0 Answers  

---

some leaves are petals some petals are flowers

3 Answers  

---

pivot table is use for?

3 Answers   eClerx, Epicenter,

---

in 25 words explain what you understand to be the difference between administrative [immigration] detention and correctional imprisonment.

0 Answers  

---

uses of Countif formula

3 Answers   eClerx,

---

QAFCO QATAR call me for interview as Senior Network Administrator. Please let me know what kind of question they asked ? Also they said they will take Written test, any idea about this written test

0 Answers   QAFCO,

---

plz send all placement /aptitude question paper of sbi bank foe clerical recruitment today only.

3 Answers   ICFAI, Wipro,

---

1) Five racing drivers, Alan, Bob, Chris, Don, and Eugene, enter into a contest that consists of 6 races. The results of all six races are listed below: Bob always finishes ahead of Chris. Alan finishes either first or last. Eugene finishes either first or last. There are no ties in any race. Every driver finishes each race. In each race, two points are awarded for a fifth place finish, four points for fourth, six points for third, eight points for second, and ten points for first. If Eugene finishes two places ahead of Chris in the first race, all of the following will be true EXCEPT: a) Bob finishes ahead of Don. b) Chris finishes two places ahead of Alan. c) Don finishes fourth. d) Bob finishes immediately behind Eugene. e) Chris finishes ahead of Bob. 2) Five racing drivers, Alan, Bob, Chris, Don, and Eugene, enter into a contest that consists of 6 races. The results of all six races are listed below: Bob always finishes ahead of Chris. Alan finishes either first or last. Eugene finishes either first or last. There are no ties in any race. Every driver finishes each race. In each race, two points are awarded for a fifth place finish, four points for fourth, six points for third, eight points for second, and ten points for first. If Don finishes third in the third race, which of the following must be true of that race? a) Alan finishes first. b) Eugene finishes first. c) Bob finishes second. d) Chris finishes second. e) Alan finishes fifth. 3) Five racing drivers, Alan, Bob, Chris, Don, and Eugene, enter into a contest that consists of 6 races. The results of all six races are listed below: Bob always finishes ahead of Chris. Alan finishes either first or last. Eugene finishes either first or last. There are no ties in any race. Every driver finishes each race. In each race, two points are awarded for a fifth place finish, four points for fourth, six points for third, eight points for second, and ten points for first. If Eugene's total for the six races is 36 points, which of the following must be true? a) Bob's total is more than 36 points. b) Chris's total is more than 36 points. c) Alan's total is 36 points. d) Don's total is less than 36 points. e) Don's total is 36 points. 4) Five racing drivers, Alan, Bob, Chris, Don, and Eugene, enter into a contest that consists of 6 races. The results of all six races are listed below: Bob always finishes ahead of Chris. Alan finishes either first or last. Eugene finishes either first or last. There are no ties in any race. Every driver finishes each race. In each race, two points are awarded for a fifth place finish, four points for fourth, six points for third, eight points for second, and ten points for first. If Alan finishes first only once, and Don finishes second exactly twice, the lowest total number of points that Bob can earn in the race is: a) 32 points. b) 38 points. c) 40 points. d) 44 points. e) 48 points. 5) Five racing drivers, Alan, Bob, Chris, Don, and Eugene, enter into a contest that consists of 6 races. The results of all six races are listed below: Bob always finishes ahead of Chris. Alan finishes either first or last. Eugene finishes either first or last. There are no ties in any race. Every driver finishes each race. In each race, two points are awarded for a fifth place finish, four points for fourth, six points for third, eight points for second, and ten points for first. If Alan finishes first in four races, which of the following could earn a total of fewer than 26 points in the six races? a) Bob only. b) Chris only. c) Don only. d) Eugene of Chris. e) Don or Chris. 6) Five racing drivers, Alan, Bob, Chris, Don, and Eugene, enter into a contest that consists of 6 races. The results of all six races are listed below: Bob always finishes ahead of Chris. Alan finishes either first or last. Eugene finishes either first or last. There are no ties in any race. Every driver finishes each race. In each race, two points are awarded for a fifth place finish, four points for fourth, six points for third, eight points for second, and ten points for first. If Frank enters the third race and finishes behind Chris and Don, which of the following must be true of that race? a) Eugene finishes first. b) Alan finishes sixth. c) Don finishes second. d) Frank finishes fifth. e) Chris finishes third.

4 Answers   Accenture, CTS, Infosys,

---

if rtd temp. is 45 degree then what would be the resistance according.(if you dont have temp. vs resistance chart)

0 Answers  

---

what i have to speak to introduce my topic

0 Answers  

---

Perl qustions,UNIX are at third section. Three sections. 1 & 2 for dsa and c apti and 3rd for (unix and perl) and dbms(only 3 questions).

1 Answers  

---

What is recruitment & wht does it actuall mein?

2 Answers  

---