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
- 1550 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
please send some sample or previous papers of karur vysya bank engineering recruitment
plz you help about Que paper of mahagenco previous your,any model paper relad to it{maharastra power genration}related to the field of electronics
tell me about your what did work in unit?
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,
what is icici?
plz send me eng apti ques and sbi clarical ques plz... bikranz4u@yahoo.com
in 25 words explain what you understand to be the difference between administrative [immigration] detention and correctional imprisonment.
what are liponyms?
(a)Give the synonyms of the following words (i) Joy (ii) Inert (iii) Jolly
what is the importance of colours in life?
150 Answers Colors, Genpact, GU, HCL, HSBC, IBM, IELS, Infosys, MFM, Microsoft, TATA, TCS, Wipro,
SSC ? Grade ?D? Exam ENGLISH CLOSET TEST TEST ? 23
my tds deduction is 654 per month,then how much investment i hve to show ?
English 
