Answer / guest

5:6

Answer / guest

a)5:6

Answer / guest

5:6

Answer / sandepe

5:6

Answer / anita

9

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  

I sudhakar i applied for the post of AAI jr. executive ( Electronics) written exam on october. I want to know the syllabus and pattern of the exam in the AAI site there is no information on syllabi......so, please be patient and forward me the syllabus for the exam my friends....... I will be very much thankful to you. my email mailid- ecsudhakar@gmail.com

0 Answers  

hi my bank of baroda written test will held on 13th march so let me know all appti question also mths question pls send me queston with answer my mail id is amrapalimohite@yahoo.com

0 Answers  

what is inspection and supervision reports and their uses

0 Answers   Genpact,

Explain the nature and characteristics of language.

0 Answers   Mahatma Gandhi University,

i come once in a day,twice in a hour,thrice in a minute.who am i?

16 Answers   IBM, Infosys,

Please send me the last 3 years question papers of State Bank of India clerical exmas, my email chanu613@gmail.com,

2 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  

please anyone post the answer for. tell me about yourself?

2 Answers   HCL, MAHINDRA, TCS,

. A man is having some money deposited in bank. In the 1st yr he gets 8% interest, 2nd yr -11 %, 3rd yr- 13%.If he gets Rs 12,400 at the end of three yr. How much he deposited.

7 Answers   Satyam,

which type of question mostly asked in this paper

0 Answers  

what types of question asked in english section

0 Answers   EON IT Park, TATA, Tata Communications, TCS,