OnlineDB/EcalCondDB/sql/num2hex.sql - master - githubmirror/cmssw

OnlineDB/EcalCondDB/sql/num2hex.sql

16 строк300 B

Andrea Bocci

Add missing newline at the end of file

27 фев 2024, 16:21

27 фев 2024, 16:21718f8fe

 
CREATE OR REPLACE FUNCTION num2hex (N IN NUMBER) RETURN VARCHAR2 IS
  H  VARCHAR2(64) :='';
  N2 INTEGER      := N;
BEGIN
  LOOP
     SELECT RAWTOHEX(CHR(N2))||H
     INTO   H
     FROM   dual;
 
     N2 := TRUNC(N2 / 256);
     EXIT WHEN N2=0;
  END LOOP;
  RETURN H;
END num2hex;
/
show errors