For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
function wordsFormula return Char is words varchar2(100); begin select upper(to_char(to_date(round(:sum_debit,'j'),'jsp')))||' RUPEES ONLY ' into words from dual; if :sum_debit=:sum_credit then return(words); else return(null); end if; end;