시작일 : P_FROM_DT 종료일 : P_TO_DT INTERVAL : 1M, 2M, 1H,2H, 1D,2D, 1W,1M WITH TBL_PARAMS AS ( SELECT , SUBSTR(:P_FROM_DT,0,8)AS STD_DAY -- 시작일 , TO_CHAR(TO_DATE( SUBSTR(:P_TO_DT, 0, 8) , 'YYYY-MM-DD')+1, 'YYYYMMDD') AS END_DAY -- 종료일 , REGEXP_REPLACE(:P_INTERVAL, '[0-9]') AS INTERVAL_TY -- MI, H, D, W, M , (CASE WHEN SUBSTR(:P_INTERVAL, 0,2) = 'MI' THEN REGEXP_REPLACE(:P_INTERVAL, '[^0-9]') * 60 ELS..

WITH T1 AS ( SELECT TO_DATE('202401010910', 'YYYY-MM-DD HH24:MI') START_DT , TO_DATE('202401010914', 'YYYY-MM-DD HH24:MI') END_DT FROM DUAL ) SELECT TO_CHAR(START_DT + (LEVEL - 1) / 24 / 60, 'YYYYMMDDHH24MI') AS GET_DAYS FROM T1 CONNECT BY LEVEL

SELECT * FROM T1 WHERE ( ( :P_PARAM_ID IS NULL -- 파라미터 없는 경우 AND TRUNC(PARAM_DT) BETWEEN '' AND '' ) OR ( :P_PARAM_ID IS NOT NULL -- 파라미터 있을 경우 AND INSTR(',' || REPLACE(:P_PARAM_ID, ' ', '') || ',', TO_CHAR(PARAM_ID)) > 0 ) ); P_PARAM_ID = 'A1,A2'

UPDATE [TABLE] SET COLUMN1 = REPLACE(COLUMN1, 'A', 'B') WHERE ID = '1'

SELECT OBJECT_NAME ,OBJECT_TYPE ,TO_CHAR(CREATED, 'YYYYMMDD') AS CREATED ,TO_CHAR(LAST_DDL_TIME, 'YYYYMMDD') AS LAST_DDL_TIME ,STATUS FROM USER_OBJECTS WHERE OBJECT_TYPE IN ('PROCEDURE', 'FUNCTION','PACKAGE') AND TO_CHAR( LAST_DDL_TIME, 'YYYYMMDD' ) >= '20231010' AND OBJECT_NAME='' ORDER BY OBJECT_TIME, OBJECT_NAME; -------------------------- SELECT OBJECT_NAME ,OBJECT_TYPE ,TO_CHAR(CREATED, 'YY..

LOOP DBMS_OUTPUT.PUT_LINE(' A '); EXIT WHEN [탈출 조건] END LOOP; WHILE [반복 조건] LOOP DBMS_OUTPUT.PUT_LINE(' A '); EXIT WHEN [탈출 조건] END LOOP;