목록Oracle (2)

infection...

64진수 -> 10진수 펑션

오라클 11g 64진수를 10진수로 변환하는 함수 시키면 깐다. create or replace FUNCTION encode64( h IN VARCHAR ) RETURN NUMBER IS h2 VARCHAR2( 10 ); i NUMBER( 10 ); j NUMBER( 2 ); d NUMBER; BEGIN h2 := LTRIM( h, '0' ); d := 0; FOR i IN 1 .. LENGTH( h2 ) LOOP SELECT DECODE(SUBSTR(h2,i,1),'0',0,'1',1,'2',2,'3',3,'4',4,'5',5,'6',6,'7',7,'8',8,'9', 9,'a',10,'b',11,'c',12,'d',13,'e',14,'f',15,'g',16,'h',17,'i',18,'j', 19,'k'..
Develop/DATABASE 2014. 12. 9. 15:45
oracle 10진수->64진수 변환 펑션

오라클 에서 10진수를 64진수로 변환하는 펑션 CREATE OR REPLACE FUNCTION decode64( a IN NUMBER ) RETURN VARCHAR2 IS x VARCHAR2( 10 ) := ''; y VARCHAR2( 1 ); z NUMBER( 2 ); w NUMBER; BEGIN w := a; WHILE w > 0 LOOP z := w mod 64; SELECT DECODE(z,0,'0',1,'1',2,'2',3,'3',4,'4',5,'5',6,'6',7,'7',8,'8',9,'9', 10,'a',11,'b',12,'c',13,'d',14,'e',15,'f',16,'g',17,'h',18,'i',19,'j', 20,'k',21,'l',22,'m',23,'n',24,'o',25,'p'..
Develop/DATABASE 2014. 12. 9. 14:47
이전 Prev 1 Next 다음