SELECT CUSTOMER_NAME AS 고객명, LENGTHB(ADDR) BYTE, -- 바이트 수 길이 LENGTHB(SUBSTRB(ADDR, 0, 70)) BYTE_1, LENGTHB(SUBSTRB(ADDR, 70, 140)) BYTE_2, SUBSTRB(ADDR, 0, 70) AS SUB_LEN1, -- 바이트 수 만큼 문자열 짜르기 SUBSTRB(ADDR, 70, 140) AS SUB_LEN1, ADDR AS 동이상주소, '' AS 동이하주소 FROM APLUSORA.TEMP_KIUM_CUSTOMER;

SELECT SUBSTR(TO_EMAIL, INSTR(TO_EMAIL,'@')+ 1,LENGTH(RTRIM(TO_EMAIL))) AS DOMAIN, COUNT(SUBSTR(TO_EMAIL, INSTR(TO_EMAIL,'@')+ 1,LENGTH(RTRIM(TO_EMAIL)))) AS DOMAIN_CNTS FROM AUTO120 WHERE WORKDAY='20121116' AND SEQNO=5 GROUP BY SUBSTR(TO_EMAIL, INSTR(TO_EMAIL,'@')+ 1,LENGTH(RTRIM(TO_EMAIL))) HAVING COUNT(SUBSTR(TO_EMAIL, INSTR(TO_EMAIL,'@')+ 1,LENGTH(RTRIM(TO_EMAIL)))) > 0 ORDER BY COUNT(SUBSTR..

* TB_INST_INPUT테이블에 SUBS_VALUE 데이터가 |구분자로 값이 들어오는 경우 -- SUBS_VALUE 컬럼의 데이터를 | 구분자로 짤라 각각 매핍변수로 선언 SELECT SUB1,SUB2,SUB3,SUB4,SUB5,SUB6,SUB7,SUB8,SUB9,SUB10,SUB11,SUB12,SUB13,SUB14, SUB15 FROM(SELECT MAX(DECODE(rowno,1,aa)) SUB1 ,MAX(DECODE(rowno,2,aa)) SUB2 ,MAX(DECODE(rowno,3,aa)) SUB3 ,MAX(DECODE(rowno,4,aa)) SUB4 ,MAX(DECODE(rowno,5,aa)) SUB5 ,MAX(DECODE(rowno,6,aa)) SUB6 ,MAX(DECODE(rowno,7,..

SELECT CASE WHEN LEN(CONVERT(VARCHAR(13),JUNO))=13 THEN SUBSTRING(JUNO,7,7) ELSE SUBSTRING(JUNO,4,7) END AS JUNO, JUNO NAMHA FROM TEST_MEMBER 주민번호 or 사업자등록번호가 올때 LENGTH로 길이를 구분하여 짜르기