ORA-04021: 객체 ○○○의 잠금 대기중 시간이 초과됐습니다 04021. 00000 - "timeout occurred while waiting to lock object %s%s%s%s%s" *Cause: While waiting to lock a library object, a timeout occurred. *Action: Retry the operation later. 오류난 해당 PACKAGE/PROCEDURE의 SID 추출 SELECT SID FROM v$access WHERE OBJECT = 'PACKAGE/PROCEDURE 명'; 해당 SID의 실행중인 SESSION 확인 SELECT SID, SERIAL#, USERNAME, STATUS FROM V$SESSION WH..

실행쿼리 WITH t AS ( SELECT 'A,B,C' OLD_VALS , '1,2,3' NEW_VALS FROM dual ) SELECT REGEXP_SUBSTR(t.OLD_VALS, '[^,]+', 1, c1.COLUMN_VALUE) AS OLD_VAL , REGEXP_SUBSTR(t.NEW_VALS, '[^,]+', 1, c1.COLUMN_VALUE) AS NEW_VAL FROM t , TABLE(CAST(MULTISET(SELECT level FROM dual CONNECT BY level

LISTAGG 조회된 복수개의 컬럼 값을 구분자로 묶어 하나의 문자열로 반환한다. ※ 반환 문자열은 최대 4000 byte 허용 -- {COLUMN_NAME} 컬럼 값을 콤마(,) 구분자로 하나의 문자열로 반환 SELECT LISTAGG({COLUMN_NAME}, ',') WITHIN GROUP (ORDER BY {COLUMN_NAME}) FROM {TABLE_NAME} -- 위 결과에서 중복값 제거 SELECT REGEXP_REPLACE(LISTAGG({COLUMN_NAME}, ',') WITHIN GROUP (ORDER BY {COLUMN_NAME}), '([^,]+)(,\1)+', '\1') FROM {TABLE_NAME}

로그 Interceptor 클래스 import java.io.IOException; import java.io.InputStream; import java.nio.charset.StandardCharsets; import org.apache.commons.io.IOUtils; import org.apache.commons.lang3.StringUtils; import org.apache.commons.lang3.builder.ToStringBuilder; import org.apache.commons.lang3.builder.ToStringStyle; import org.springframework.http.HttpRequest; import org.springframework.http.HttpStatu..

유효성 검사기 import java.util.Collection; import java.util.List; import javax.validation.Validation; import org.springframework.stereotype.Component; import org.springframework.validation.BindingResult; import org.springframework.validation.Errors; import org.springframework.validation.ObjectError; import org.springframework.validation.SmartValidator; import org.springframework.validation.beanvalidat..

날짜 범위 확인 java.text.SimpleDateFormat df = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); java.util.Date nowDt = new java.util.Date(); Range rangeDate = Range.between(df.parse("2020-03-17 00:00:00"), df.parse("2020-04-08 23:59:59")); if (rangeDate.contains(nowDt)) { ... } ..