Implicit Cursor Problem

From: Tajdar Jawaid <tajdar_at_cyber.net.pk>
Date: 2000/05/31
Message-ID: <39350C62.D120BF84@cyber.net.pk>#1/1

This is the Query

   SELECT SUBSTR(RECEIPT_NO,1,10) RECEIPT,

   SUBSTR(RECEIPT_ACCOUNT_NO,1,10) CUSTOMER,
   SUBSTR(RECEIPT_FIRST||' '||RECEIPT_LAST,1,25) NAME,
   SUBSTR(RECEIPT_PACKAGE,1,15) PACK,
   SUBSTR(RECEIPT_PAYMENT_MODE,1,10) PAYMODE,
   SUBSTR(RECEIPT_K_CODE,1,15) DES,
   SUBSTR(RECEIPT_TAX,1,1) TAX,
   SUBSTR(RECEIPT_AMOUNT,1,10) AMOUNT

  FROM RECEIPT_DETAIL_T
  WHERE TRUNC(CYB_DATE_CONVERTER(CREATED_T))='22-MAY-00'   AND RECEIPT_PACKAGE='Corporate'

and this is the result

RECEIPT    CUSTOMER   NAME                      PACK

PAYMODE DES
T AMOUNT
---------- ---------- ------------------------- ---------------

• --------------- -

  ---

  196863 1071371 Samad Works (Pvt) Ltd. Corporate cash II 2400 196863 1071371 Samad Works (Pvt) Ltd. Corporate cash ss 1200 196869 1055228 Aqeel Pervaiz Corporate check II 5176 196929 1054900 Abdul Razzak Jangda Corporate check II 8708 197007 1071439 PR News Corporate cash II 2400 197007 1071439 PR News Corporate cash ss 1200

but I want the result like this

RECEIPT    CUSTOMER   NAME                      PACK

PAYMODE DES
T AMOUNT
---------- ---------- ------------------------- ---------------

• --------------- -

  ---

  196863 1071371 Samad Works (Pvt) Ltd. Corporate cash II 2400

cash       ss                1200


----------------------------------------------------------------------------------------------------

Total:
3600

---

196869     1055228    Aqeel Pervaiz                     Corporate
check      II                5176


----------------------------------------------------------------------------------------------------

Total:
5176

---

196929     1054900    Abdul Razzak Jangda         Corporate
check      II                8708


----------------------------------------------------------------------------------------------------

Total:
8708

---

197007     1071439    PR News                           Corporate
cash        II                2400

cash       ss                1200


----------------------------------------------------------------------------------------------------

Total:
3600

---

---

Grand Total:
21084

---

If the customer is same then just get his second payment mod,description and amount and his
total;

If you have some solution in PL/SQL or SQl

then I m waiting

Regards

Tajdar Jawaid Received on Wed May 31 2000 - 00:00:00 CDT