Tuesday, June 21, 2022

Sql - comma function

 CREATE OR REPLACE FUNCTION EX_number_format( ff number) RETURN char IS

   xx varchar2(100);

   yy varchar2(1);

   tt varchar2(100);

  x number:=0;

  begin

   xx:=to_char(ff,'99G990G990G990G990G990D00');

  for i  in 1..length(xx) loop

   yy:=substr(xx,i,1);

 if yy in ('1','2','3','4','5','6','7','8','9') then

  x:=i;

 exit;

 end if;

 end loop;

 tt:=substr(xx,x,length(xx));

return tt;

 END EX_number_format;


No comments:

Post a Comment

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...