Java 개발 블로그

연결 가능 최대 커넥션 수 확인 show variables like '%max_connect%'; 현재 커넥션 사용 수 확인 show global status like 'threads_connected';

이전 데이터 조회 AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '100' MINUTE) 여러줄 한 컬럼으로 합치기 REPLACE(WM_CONCAT(column), ',', '^')

SELECT SYSDATE , TO_CHAR(SYSDATE, 'YYYY-MM-DD') , LTRIM((TO_CHAR(SYSDATE, 'YYYY')), '0') AS YEAR , LTRIM((TO_CHAR(SYSDATE, 'MM')), '0') AS MONTH , LTRIM((TO_CHAR(SYSDATE, 'DD')), '0') AS DAY FROM DUAL

SELECT TRUNC(123456789, -1) AS 원단위_절사 FROM DUAL

with cte_list as ( select 'test1234' as title from dual union all select 'test' as title from dual union all select 'test1' as title from dual union all select 'test233' as title from dual union all select 'test444' as title from dual union all select 'test113' as title from dual union all select 'testabdd' as title from dual ) select title from cte_list where title like '%test%' ORDER BY UTL_MA..