Display field value in Oracle Reports 10g
i have a field with totalpages =5 i need to display the value with = five
in report 10g
Software/Hardware used:
Software/Hardware used:
ASKED:
May 4, 2009 7:03 AM
UPDATED:
January 13, 2011 5:15 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
Could you please explain your requirement.
It is not clear enough.
What it sounds like is that you want to spell out the number instead of printign the numeric value. Print the word ‘FIVE’ instead of the number ’5′.
Here is a piece of SQL that you can use to acomplish this.
~~~~~~~~~~~~~~~
myanswer varchar2(500);
begin
mynumber := 0;
for mynumber in 101..109 loop
select to_char(to_date(trunc(mynumber),’J'),’Jsp’)
into myanswer
from dual;
dbms_output.put_line (mynumber ||’ Spelled out: ‘||myanswer);
end loop;
end;