decode and least function

[blurryhaddad]

hi all..
i dont understand this sql statement(decode and least)
please help me..

sum(decode(f.code_category,'3', nvl(decode(d.flag_result,null,decode(least(b.date, :p_startingdate+1)b.date,1),0),1),0))

please convert this to if and else statement...so that i can understand...thank you..

[debasisdas]

As you have posted a qustion it articles section it is moved to Oralce forum.

MODERATOR.

[debasisdas]

hi all..
i dont understand this sql statement(decode and least)
please help me..

sum(decode(f.code_category,'3', nvl(decode(d.flag_result,null,decode(least(b.date, :p_startingdate+1)b.date,1),0),1),0))

please convert this to if and else statement...so that i can understand...thank you..

decode returns a particular value is the condition is satisfied or the 2nd value if the second cond is satisfied ,if no condition satisfies the it returns null,it else statment is not specified.

least ---returns the least value in the list , in your case the least date out of two daes.

I can convert it to IF ...ELSE


but the problem is it is not possible to execute IF ....ELSE directly in sql statments.

if u stilll have doubts please dopost back.

[nramrits]

CHECK THIS IF ..ELSE FORMATE
SUM(
IF f.code_category=3
THEN
IF d.flag_result= null
THEN
IF b.date <= p_startlngdate+1 THEN
RETURN(b_date)
END IF;
ELSE-- NOT NULL THEN
RETURN 1;
END IF;
ELSE
RETURN (0)
END IF