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 ?
- 0 Answers
- 1950 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
SSC ? Grade ?D? Exam ENGLISH CLOSET TEST TEST-11
Please send me SBI exam model question paer by mail.....
0 Answers Infosys, ITC Infotech, State Bank Of India SBI,
what are jargons?
write code for calculating Standard Deviation in c sharp
What does waiver mean?
SSC ? Grade ?D? Exam ENGLISH CLOSET TEST TEST-9
plz forward me lakshmi vilas bank previous clerk papers or any model papers
4 Answers Lakshmi Vilas Bank, LVB,
what is filtration??? what is decantation??? what will be the difference between the products of filtration and decantation???
SSC ? Grade ?D? Exam ENGLISH CLOSET TEST TEST-5
founder of chinese republic
Mention any two principles of behaviourism with regard to language learning.
0 Answers Mahatma Gandhi University,
Identify the sentence(S)that is/are showing the correct use of the underlined words : The word:scathe (1)We are advised to buy a lawn mower and get rid of this scathe once and for all ! (2)With perservance and hard work,you are earninf quite a scathing reputation (3)It was not the judgement,but his scathing remarks that had truly hurt. A) 2 ONLY B) 3 ONLY C)BOTH 1 AND 2 D) BOTH 2 AND 3 E)all three sentences please give 100 examples of this kind of question with answers
English 
