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 ?
No Answer is Posted For this Question
Be the First to Post Answer
what is html
i MATHI PREPARING FOR BANK EXAMS PLEASE SEND ME A MODEL QUESTION PAPER FOR MY PREPARATION. WITH KIND REGARDS MATHI
Please send me SBI exam model question paer by mail.....
0 Answers Infosys, ITC Infotech, State Bank Of India SBI,
Which of the following OSPF commands, when used together, will put the network 192.168.10.0/24 into OSPF area 0?
what are jargons?
. A train travels a certain distance taking 7 hrs in forward journey, during the return journey increased speed 12km/hr takes the times 5 hrs.What is the distance traveled
What is the your Aim ?
information about establishement of company.who is the founder of company.
when u loved someone and he/she is trying to throw a grenade in crowed place. wht u will do? do u kill him/her or not. THe answer shold be writeen altest one page. Please help me in this by posting the answer to sruthi_53@yahoo.co.in
How to calculate the area of a square plate with certain thinkness?
i am a college student in our place...i have a question What is the most question use in interviewing a company for making a system analysis and design proposal. give me some exmple for the open ended question and closed ended?
how to prepare for SBI Clarks