PL/SQL (MOSC)

MOSC Banner

sql scripts help

edited Sep 2, 2009 3:16AM in PL/SQL (MOSC) 5 commentsAnswered
hi,
i have this script:
select r.cust_name,r.code,p.ded_desc4,p.ded_amt1,p.ref_no,r.remarks
from receipts r,payments p
where r.code=p.rct_code
and r.pcode=p.pcode
and r.pcode='principal'
and r.bank_provider='CTB'
and to_char(r.date_issued,'yyyymmdd')='date'

which likelyhave an output:
cust_name          code       ded_desc4       ded_amt1          ref_no                  remarks
client1                 1234       rtv456111         1456                 1500000              test
client1                  1235      rtv456221          1451                 1600000             test
client2                  1245      dmi12212         1245                  2100000             test

now i do wish in cust_name column not to repeat the data since it has the same value

which the new output will be:

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