Java 개발 블로그

이전 데이터 조회 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..