subinto의 개발노트

SELECT
ORA_ROWSCN AS SCN
, TO_CHAR(SCN_TO_TIMESTAMP(ORA_ROWSCN),'YYYY-MM-DD HH24:MI:SS') AS TM
, MENU_ID
FROM TB_MENU_INFO;

SELECT  * 
  FROM TB_MENU_INFO  AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '10' MINUTE) 
 WHERE  MENU_ID LIKE 'SC_%'

--특정 날짜 시간 데이터 조회
SELECT  * 
  FROM TB_MENU_INFO  AS OF TIMESTAMP(TO_TIMESTAMP('2018-11-12 08:30:10', 'YYYY-MM-DD HH24:MI:SS')) 
 WHERE  MENU_ID LIKE 'SC_%'

/*
 * MENU_ID가 PK임
 * MENU_CATE데이터가 'B', 'I', 'P' 인것의 MENU_TYPE별 개수 구하기
 */
WITH PV AS (
    SELECT MENU_ID
              , MENU_CATE
              , MENU_TYPE
      FROM TB_SF_MENU_INFO
)
SELECT *
  FROM PV
  PIVOT(COUNT(MENU_ID) FOR MENU_TYPE IN ('B' AS TYPE_B, 'I' AS TYPE_I, 'P' AS TYPE_P));