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
- 2023 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What are your strengths? What are your weaknesses? Why are you interested in working for [insert company name here]? Where do you see yourself in five years? Ten years? Why do you want to leave your current company? Why was there a gap in your employment between [insert date] and [insert date]? What can you offer us that someone else can not? What are three things your former manager would like you to improve on? Are you willing to relocate? Are you willing to travel? Tell me about an accomplishment you are most proud of. Tell me about a time you made a mistake. What is your dream job? How did you hear about this position? What would you look to accomplish in the first 30 days/60 days/90 days on the job? Discuss your resume. Discuss your educational background. Describe yourself. Tell me how you handled a difficult situation. Why should we hire you? Why are you looking for a new job? Would you work holidays/weekends? How would you deal with an angry or irate customer? What are your salary requirements? (Hint: if you’re not sure what’s a fair salary range and compensation package, research the job title and/or company on Glassdoor.) Give a time when you went above and beyond the requirements for a project. Who are our competitors? What was your biggest failure? What motivates you? What’s your availability? Who’s your mentor? Tell me about a time when you disagreed with your boss. How do you handle pressure? What is the name of our CEO? What are your career goals? What gets you up in the morning? What would your direct reports say about you? What were your bosses’ strengths/weaknesses? If I called your boss right now and asked him what is an area that you could improve on, what would he say? Are you a leader or a follower? What was the last book you’ve read for fun? What are your co-worker pet peeves? What are your hobbies? What is your favorite website? What makes you uncomfortable? What are some of your leadership experiences? How would you fire someone? What do you like the most and least about working in this industry? Would you work 40+ hours a week? What questions haven’t I asked you? What questions do you have for me?
why is a personnel function required in all organisation and how applicable are business objectives to it
When u loved someone and he/she is trying to throw a grenade in crowed place. What you will do ? you will kill him/her ? For this sentence we need to write an essay altest 1 page. Please help me in this by posting the answers to sruthi_53@yahoo.co.in
how do you identify your self?
is the sentence correct? "two and two makes four
send me aptitude question paper at my email id
Hi, I forgot rollnumber for Intelligence Bureau officer held on 20ll. How to find my roll number, plz help me.
hi guys, how to prepare for INDIAN BANK clerk exam,pls gave me any suggestions, abt related on bank exams,prvs examinors on iob done, pls told me how to prepare for exams, abt timings etc.
which insurance company is with ambit
partner and join are same or not
2 Answers Bank Of America, Yardi,
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).
what are liponyms?
English 
