hai team members pls send sbi bank clerk exam model
question paper to my email id faruque_mullick@yahoo.co.in
22
give me the pervious years question paper of sbi clerical
exam
26
In a colony there are some families. Each of them have
children but different in numbers.Following are conditions
a> no of adult>no of sons>no of daughters>no of families.
b>each sister must have atleast one brother and should
have
at the most
1 sister.
c> no of children in one family exceeds the sum of no of
children in the rest families
Tell the no of families
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 ?
I have 125 maths questions fully answered with detailed
explanation for bank clerk test. Since I paid for it, if
you are ready to share the price, I can share it with
others just for Rs.50. If interedsted, mail
me:beenasbi@gmail.com
Hi fnds..
I am doing Finar MCA ... I want US TECHNOLOGY RECENT
Palcement paper.Can any one help me.
velusamy.s@kgisliim.ac.in plz send to this mail id...
Site Map