반응형 전체 글22 KeyDown시 Key값 KeyDown시 key값 ($ )------------------------ VK_A 41 A key VK_B 42 B key VK_C 43 C key VK_D 44 D key VK_E 45 E key VK_F 46 F key VK_G 47 G key VK_H 48 H key VK_I 49 I key VK_J 4A J key VK_K 4B K key VK_L 4C L key VK_M 4D M key VK_N 4E N key VK_O 4F O key VK_P 50 P key VK_Q 51 Q key VK_R 52 R key VK_S 53 S key VK_T 54 T key VK_U 55 U key VK_V 56 V key VK_W 57 W key VK_X 58 X key VK_Y 59 Y key VK_Z .. 2023. 11. 16. 소계, 합계 (ROLLUP 함수) SELECT DECODE(GROUPING(AA),1,'총')||NVL(A.WKYY,'계') WKYY, SUM(BASICAMT) BASICAMT, EVALTOTAL, CASE WHEN A.GUBUN='2' THEN 'AAA' WHEN A.GUBUN='3' THEN 'BBB' ELSE LTIPER END LTIPER, SUM(GLTIAMT) GLTIAMT, DIVISION, A.GUBUN, PAYYY1, NLTIAMT1, PAYYY2, NLTIAMT2, PAYYY3, NLTIAMT3, PAYYY4, NLTIAMT4, PAYYY5, NLTIAMT5, SUM("2019.01"), SUM("2020.01"), SUM("2021.01"), SUM("2022.01"), SUM("2023.01") ,AA ,CASE W.. 2023. 4. 19. pivot, unpivot 여러개 처리 * PIVOT SELECT * FROM ( SELECT 1 KEY1 , 1 SEQ, '1' COL1 , '1000' COL2, '1000' COL3 FROM DUAL UNION ALL SELECT 1 KEY1 , 2 SEQ, '2' COL1 , '2000' COL2, '5000' COL3 FROM DUAL ) PIVOT (MAX(COL1) AS COL1, MAX(COL2) AS COL2, MAX(COL3) AS COL3 FOR SEQ IN (1 AS R1, 2 AS R2)) * UNPIVOT SELECT * FROM ( SELECT '282' COL1, '1' COL2 , '홍길동1' R1_L_02, '12345' R1_L_02_1, '20200101' R1_L_03, 'Y' R1_L_04 , '홍길동2.. 2023. 4. 19. pivot, unpivot 여러개 처리 * PIVOT SELECT * FROM ( SELECT 1 KEY1 , 1 SEQ, '1' COL1 , '1000' COL2, '1000' COL3 FROM DUAL UNION ALL SELECT 1 KEY1 , 2 SEQ, '2' COL1 , '2000' COL2, '5000' COL3 FROM DUAL ) PIVOT (MAX(COL1) AS COL1, MAX(COL2) AS COL2, MAX(COL3) AS COL3 FOR SEQ IN (1 AS R1, 2 AS R2)) * UNPIVOT SELECT * FROM ( SELECT '282' COL1, '1' COL2 , '홍길동1' R1_L_02, '12345' R1_L_02_1, '20200101' R1_L_03, 'Y' R1_L_04 , '홍길동2.. 2023. 4. 5. TreeView를 그려주고 FullExpand 한 다음 제일 위쪽으로 옮길때 PictureTreeView.TopItem := PictureTreeView.Items.GetFirstNode; 2023. 3. 17. Key값 관련 블록선택 : Shift + Alt + 화살표 블록선택된것 해제 : ctrl + O 다음 K KeyDown시 key값 ($ )------------------------ VK_A 41 A key VK_B 42 B key VK_C 43 C key VK_D 44 D key VK_E 45 E key VK_F 46 F key VK_G 47 G key VK_H 48 H key VK_I 49 I key VK_J 4A J key VK_K 4B K key VK_L 4C L key VK_M 4D M key VK_N 4E N key VK_O 4F O key VK_P 50 P key VK_Q 51 Q key VK_R 52 R key VK_S 53 S key VK_T 54 T key VK_U 55 U key VK_V 56 V .. 2023. 3. 17. FUNCTION 예제 CREATE OR REPLACE FUNCTION SECVIP.SF_WORKID(P_YYYY IN VARCHAR2, P_JUCHA in varchar2) RETURN VARCHAR2 IS P_RESULT VARCHAR2(10); BEGIN SELECT P_YYYY||P_JUCHA||LPAD(TO_CHAR(NVL(MAX(SUBSTR(WORKID,7,4))+1,1)),4,'0') INTO P_RESULT FROM SEV_WORK WHERE WORKID LIKE P_YYYY||P_JUCHA||'%'; RETURN P_RESULT; END; 2023. 1. 27. 토드에서 메뉴 느린것 윈도우 시작 - 설정 - 접근성 - 디스플레이 - Windows에서 애니메이션 표시 끄기 2023. 1. 27. 토드에서 프러시저 실행 declare P_ERRNO varchar2(100); P_ERRMSG2 varchar2(100); begin SP_SEV_M_VIEW_MD_SAL_EVALLIST('F2276EA0A2AE11D9916ED4E329AFD1FF', 'd2a004c70bd445cc4bb76bbe6a263e5f2bd782d73280c3917e03eb008487cbb2', P_ERRNO, P_ERRMSG2, :O_CUR); end; 2023. 1. 27. LAG , LEAD 함수 * LAG 함수 : 이전값 리턴 LEAD 함수 : 이후값 리턴 https://dlfma1985.tistory.com/24 2023. 1. 27. 이전 1 2 3 다음 반응형