Update Subquery

UPDATE TABLE1 SET TABLE1.COLUMN1 = (SELECT COL1 FROM TABLE2 WHERE TABLE2.COL2 = TABLE1.COLUMN2 AND TABLE2.COL3 = TABLE1.COLUMN3)
Study/Oracle 2014. 3. 4. 15:58
가변적 쿼리 실행하기

V_SQL := 'SELECT ROWNUM FROM DUAL CONNECT BY LEVEL
Study/Oracle 2014. 2. 25. 11:59
오라클 Row를 한 컬럼으로 변경하기(11g Only)

SELECT LISTAGG (ROWNUM, ',') WITHIN GROUP (ORDER BY ROWNUM) FROM DUAL CONNECT BY LEVEL
Study/Oracle 2014. 2. 25. 11:40
오라클 특정 Row를 가진 더미 테이블 만들기

SELECT ROWNUM FROM DUAL CONNECT BY LEVEL
Study/Oracle 2014. 2. 21. 14:43
주차별 날짜 구하기 쿼리

SELECT INITCAP(TO_CHAR (MIN (D) + 6, 'MON.DD','NLS_DATE_LANGUAGE=AMERICAN')) || ' - ' || INITCAP(TO_CHAR (MAX (D) + 6, 'MON.DD','NLS_DATE_LANGUAGE=AMERICAN')) AS WEEK_DAY FROM ( SELECT TO_DATE ('20140101', 'YYYYMMDD') + (ROWNUM - 1) d FROM DUAL CONNECT BY LEVEL
Study/Oracle 2014. 2. 19. 09:31
1