how can i put multiple statmwnts in sum(case...

#21

as Charles pointed, i used the decode function as an if statement and
this solved my problem just like that:

sum(decode(cust_1.region, 'East', decode(prod_1.category, 'Base',
0.095,'Common', 0.115,
'Special',0.14, 0)*salpmt_1.amount, 0)) as "East", ...

that was it.
Thanks to all of you, you were all helpful

#22

Totti wrote:

Quote:

as Charles pointed, i used the decode function as an if statement and
this solved my problem just like that:

sum(decode(cust_1.region, 'East', decode(prod_1.category, 'Base',
0.095,'Common', 0.115,
'Special',0.14, 0)*salpmt_1.amount, 0)) as "East", ...

that was it.
Thanks to all of you, you were all helpful

Well done Charles. I was still trying to figure out what the question was.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#23

Totti wrote:

Quote:

as Charles pointed, i used the decode function as an if statement and
this solved my problem just like that:

sum(decode(cust_1.region, 'East', decode(prod_1.category, 'Base',
0.095,'Common', 0.115,
'Special',0.14, 0)*salpmt_1.amount, 0)) as "East", ...

that was it.
Thanks to all of you, you were all helpful

Well done Charles. I was still trying to figure out what the question was.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#24

Totti wrote:

Quote:

as Charles pointed, i used the decode function as an if statement and
this solved my problem just like that:

sum(decode(cust_1.region, 'East', decode(prod_1.category, 'Base',
0.095,'Common', 0.115,
'Special',0.14, 0)*salpmt_1.amount, 0)) as "East", ...

that was it.
Thanks to all of you, you were all helpful

Well done Charles. I was still trying to figure out what the question was.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#25

Totti wrote:

Quote:

as Charles pointed, i used the decode function as an if statement and
this solved my problem just like that:

sum(decode(cust_1.region, 'East', decode(prod_1.category, 'Base',
0.095,'Common', 0.115,
'Special',0.14, 0)*salpmt_1.amount, 0)) as "East", ...

that was it.
Thanks to all of you, you were all helpful

Well done Charles. I was still trying to figure out what the question was.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

how can i put multiple statmwnts in sum(case...

comp.databases.oracle.misc comp.databases.oracle.misc

Re: how can i put multiple statmwnts in sum(case... - 01-06-2008 , 12:34 PM

Re: how can i put multiple statmwnts in sum(case... - 01-06-2008 , 03:21 PM

Re: how can i put multiple statmwnts in sum(case... - 01-06-2008 , 03:21 PM

Re: how can i put multiple statmwnts in sum(case... - 01-06-2008 , 03:21 PM

Re: how can i put multiple statmwnts in sum(case... - 01-06-2008 , 03:21 PM