This is more out of curiosity than anything...I know Decode is only available in SQL.
I know in PL/SQL I can type out something like this...the function is irrelevant, just an example
if (P_COMMIT = 'Y') then
v_commit := 'Validate and Load';
else
v_commit := 'Validate Only';
end if;
myFunction('P_COMMIT', v_commit);
Just because I like to keep things a simple and short as possible, it would sure be nice to be able to just write this...just wondering if there's any new PL/SQL functions out there I've missed that would help simplify things?
myFunction('P_COMMIT', decode(P_COMMIT, 'Y', 'Validate and Load', 'Validate Only'));