-
I am trying to create a report in SQLPLUS using the functions "break on" and "compute". But I am not getting the desired results. The SQL is as follows:
BREAK ON SERVICE_OID skip 2
COMPUTE SUM OF FLAT_RATE ON SERVICE_OID
SELECT substr(SERVICE_OID, 1, 25), substr(NVL(FLAT_RATE, 0), 1, 10)
FROM CONTRACT_SERVICE
WHERE SERVICE_OID IN ('S095', 'S096', 'S097', 'S098')
ORDER BY SERVICE_OID
the results are being shown as follows:
SUBSTR(SERVICE_OID,1,25) SUBSTR(NVL
------------------------- ----------
S095 1500
S095 2000
S096 0
S097 0
S097 0
S097 0
S097 0
S097 0
S098 0
S098 0
S098 0
S098 0
What is it that I am missing in my statement? I appreciate the help.
Thanks,
Chintz
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|