SQL> create or replace
spell_number función (p_number en número) function spell_number( p_number in number )
retorno varchar2 como return varchar2 as
myArray tipo es la tabla de varchar2 (255);type myArray is table of varchar2(255);
myArray l_str: = myArray (”, l_str myArray := myArray( ”,
‘Mil’, ‘millones de euros », ‘ thousand ‘, ‘ million ‘,
‘Mil millones’, ‘billones’, ‘ billion ‘,’ trillion ‘,
‘, Billones’ trillones ‘, ‘ quadrillion ‘, ‘ quintillion ‘,
‘, Sextillones’ septillón ‘, ‘ sextillion ‘, ‘ septillion ‘,
‘, Octillones’ nonillion ‘, ‘ octillion ‘, ‘ nonillion ‘,
‘,Decillion’ undecillion ‘, ‘ decillion ‘, ‘ undecillion ‘,
‘Duodecillion’); ‘ duodecillion ‘ );
l_num VARCHAR2 (50) Tronco defecto (p_number); l_num varchar2(50) default trunc( p_number );l_return VARCHAR2 (4000); l_return varchar2(4000);
empezar begin
i en 1 .. for i in 1 .. bucle l_str.count l_str.count loop
de salida cuando l_num es nulo; exit when l_num is null;
if (substr (l_num,longitud (l_num) -2, 3) 0) entonces if ( substr(l_num, length(l_num)-2, 3) 0 ) then
l_return: = to_char (to_date (substr (l_num, longitud (l_num) -2, 3), ‘J’), ‘Jsp’) | | l_str (i) | | l_return;l_return := to_char(to_date(substr(l_num, length(l_num)-2, 3),’J’ ),’Jsp’ ) || l_str(i) || l_return;
END IF; end if;
l_num: = substr (l_num, 1, longitud (l_num) -3); l_num := substr( l_num, 1,length(l_num)-3 );
end loop; end loop;
l_return retorno; return l_return;
final; end;
Función creada. Function created.
SQL> spell_number seleccionar (‘1053550 ‘) from dual; SQL> selectspell_number(‘1053550’) from dual;
SPELL_NUMBER (‘1053550 ‘) SPELL_NUMBER(‘1053550’)
————————————————– ————————————————————
Un millón cincuenta y tres mil quinientos cincuenta y One million Fifty-Three thousand Five Hundred Fifty
Recuerdos, Regards,
Rana Irfan Rana Irfan
SQL> create or replace function…
