Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

group by on data block

abcdxyzNov 18 2010 — edited Nov 18 2010
Hi all

sorry for troubling u frequently actually i am in a firefighting mode and the deadline of the forms is by weekend and i am relatively new to forms

i have a summary block on which i want to use a where clause where there is a group by
the summary data block consists of 4 columns
order_number,part_number,status,quantity
i want to display the records based on the sum(quantity)
basically
select order_number,part_number,status,sum(quantity)
from summary
where order_number = order number from the control block form
and part number =part number from the control block form
and status = status from the control block form
group by order_number,part_number,status

is it possible to write my where clause as
where order_number = order number from the control block form
and part number =part number from the control block form
and status = status from the control block form
group by order_number,part_number,status

and if yes where do i specify the sum(quantity)


please help me

thanks a lot for your help you are providing me

thanks
satish
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 16 2010
Added on Nov 18 2010
4 comments
1,219 views