PL/SQL (MOSC)

MOSC Banner

delete lines

edited Jan 21, 2011 1:25AM in PL/SQL (MOSC) 5 commentsAnswered
hi, i have this forms :
 

DECLARE

   CURSOR C1 IS

   SELECT COUNT(*) TOT_COUNT

   FROM sbis.bayadcenter b

   where b.cust_code='CUST01';

 

   CURSOR C IS

   SELECT b.cisi,b.dep_date,b.branch,b.drn_no,b.chk_no,b.chk_amt,amt.tot_amt

   FROM (select b.drn_no,sum(chk_amt) tot_amt

                 from sbis.bayadcenter b

                where b.cust_code='CUST01'

                and b.dep_date= :cgtemp.dep_date

                group by b.drn_no) amt, sbis.bayadcenter b

   where b.cust_code='CUST01'

   and b.dep_date= :cgtemp.dep_date

   and b.drn_no=amt.drn_no;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center