So bloody thorough! Ah! So happy and blessed out! I feel redeemed by reading out SQL String Functions. Keep up the good work!
To some of you this question is simple to answer. For me it took some time of watching youtube, learning in internet and still got no answer to this.
Lets say I have data in Table_X:
And I want to get this from my excel query:
My query is this:
SELECT Client_id, SUM ( CASE WHEN (Voucher type = 'M20') THEN Amount ELSE 0 END) AS "Amount M20", SUM ( CASE WHEN (Voucher type = 'IP4') THEN Amount ELSE 0 END) AS "Amount IP4", Activity FROM TABLE_X WHERE Activity IS NOT NULL
And Output is missing IP4 calculation, because of Where condition:
But if I remove Where condition, then I get doubling of rows and this is far away from my desired output.
Database’s overall physical architecture is maintained in a file called control file. It will be used to maintain internal consistency and guide recovery operations. Multiple copies of control files are advisable.
THANK YOU!! This saved my butt today, I’m immensely grateful.
Hello Dayakar,
ReplyDeleteSo bloody thorough! Ah! So happy and blessed out! I feel redeemed by reading out SQL String Functions. Keep up the good work!
To some of you this question is simple to answer. For me it took some time of watching youtube, learning in internet and still got no answer to this.
Lets say I have data in Table_X:
And I want to get this from my excel query:
My query is this:
SELECT
Client_id,
SUM ( CASE WHEN (Voucher type = 'M20')
THEN Amount
ELSE 0
END) AS "Amount M20",
SUM ( CASE WHEN (Voucher type = 'IP4')
THEN Amount
ELSE 0
END) AS "Amount IP4",
Activity
FROM TABLE_X
WHERE Activity IS NOT NULL
And Output is missing IP4 calculation, because of Where condition:
But if I remove Where condition, then I get doubling of rows and this is far away from my desired output.
Database’s overall physical architecture is maintained in a file called control file. It will be
used to maintain internal consistency and guide recovery operations. Multiple copies of control files are advisable.
THANK YOU!! This saved my butt today, I’m immensely grateful.
Thank you,
Joel
Selamat Petang,
ReplyDeleteThe challenge however, is we don’t yet know how it will be used making to hard to assess their value proposition and consequently value.
how to apply refcursor in package with multiple insted of multple cursors in oracle?
Give one example.
Thank you very much and will look for more postings from you.
Regards,