SELECT MIN(DECODE(week,'1',day)) SUN,
MIN(DECODE(week,'2',day)) MON,
MIN(DECODE(week,'3',day)) TUE,
MIN(DECODE(week,'4',day)) WED,
MIN(DECODE(week,'5',day)) THU,
MIN(DECODE(week,'6',day)) FRI,
MIN(DECODE(week,'7',day)) SAT
FROM (
SELECT LEVEL day, to_char(to_date('200905','YYYYMM')+LEVEL-1,'D') week
FROM DUAL
CONNECT BY LEVEL <= to_char(last_day(to_date('200905','YYYYMM')),'DD')
)
GROUP BY day +7 - week
ORDER BY 7
'개발/Oracle'에 해당되는 글 5건
- 2012.09.14 오라클 달력 만들기
- 2012.06.28 Multi row update
- 2012.05.02 linux sqlplus에서 ed(edit)사용 시 vi 에디터 사용법
- 2012.04.20 테이블 인덱스 확인 쿼리
- 2012.04.20 계층 구조의 조회
update STB_STORE@SCKWEB A SET A.STORE_BIZ_CD = (
SELECT B.BRANCH_CODE FROM MSR_BRANCH_INFO B
WHERE B.BRANCH_NAME = REPLACE(A.STORE_NM, '점', '')
)
WHERE REPLACE(A.STORE_NM, '점', '') IN (SELECT BRANCH_NAME FROM MSR_BRANCH_INFO);
$ORACLE_HOME/sqlplus/admin/glogin.sql에
define_editor=vi
추가
SELECT A.uniqueness, b.* FROM ALL_INDEXES a, ALL_IND_COLUMNS b WHERE a.index_name = b.index_name AND a.table_name=upper('big_emp');