exhibitlove

출처 : https://brownbears.tistory.com/537 SELECT C1, C2, C3, 집계함수(C4) FROM TABLE_NAME GROUP BY ROLLUP (C1, C2, C3); -- 특정 컬럼 제외 가능 SELECT C1, C2, C3, 집계함수(C4) FROM TABLE_NAME GROUP BY C1 ROLLUP (C2, C3);

function chkfile(event) { console.log($(event.currentTarget).val()); }

SELECT Count(*) FILTER(WHERE pay_ymd between '2023-10-01' and '2023-10-31') as pay_cnt FROM tb_pay_tx_dtl

// option 삭제 $("#sel").find("option").each(function() { if(this.value != "") { $(this).remove(); } } // option 삭제 한줄로 $("#sel").children("option:not(:first)").remove(); // option 추가 var objsel = document.getElementById("sel"); var objOption = document.createElement("option"); objOption.text ="선택1"; objOption.value = "option1"; objsel.options.add(objOption); remove와 empty의 차이 !! empty : 선택된 요소의 하..

WITH MERGE_ITVL_TYPE AS ( UPDATE SPPDB.TB_ITVL_TYP SET ITVL_TYP_CD_NM = #itvlTypeCodeName) ,ITVL_TYP_CD_EXPL = #{itvlTypeCodeExpl} ,DPST_USE_YN = #{itvlDpstuseFlag} ,ADJ_USE_YN =#{itvlAdjuseFlag} ,USE_YN= #{itvlUseFlag} ,UPDT_DT = NOW() WHERE ITVL_TYP_CD = #{itvlTypeCode} AND ITVL_TRM = #{itvlTerm} RETURNING * ) INSERT INTO SPPDB.TB_ITVL_TYP (ITVL_TYP_CD, ITVL_TRM, ITVL_TYP_CD_NM, ITVL_TYP_CD_EX..

출처:https://blog.nachal.com/m/1631 1. 테이블의 주석(코멘트/설명) 출력 /* 테이블 주석 셀렉트 */ SELECT N.NSPNAME, C.RELNAME, OBJ_DESCRIPTION(C.OID) FROM PG_CATALOG.PG_CLASS C INNER JOIN PG_CATALOG.PG_NAMESPACE N ON C.RELNAMESPACE=N.OID WHERE C.RELKIND = 'r' AND NSPNAME = '데이터베이스명' AND RELNAME = '테이블명' 2. 테이블의 컬럼명과 주석(코멘트/설명) 출력 /* 컬럼 주석 셀렉트 */ SELECT PS.RELNAME AS TABLE_NAME, PA.ATTNAME AS COLUMN_NAME, PD.DESCRIPTION ..

SELECT POSITION('S' IN 'PostgreSQL POSITION')

출처 :https://m.blog.naver.com/adamdoha/222477256466 Specified in java.security to indicate the caching policy for un-successful name lookups from the name service.. The value is specified as integer to indicate the number of seconds to cache the failure for un-successful lookups. A value of 0 indicates "never cache". A value of -1 indicates "cache forever". ​ 해석: 기본값은 10이며, DNS 주소를 받아오지 못했을 때의 캐시..