Notice
Recent Posts
Recent Comments
Link
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | |
7 | 8 | 9 | 10 | 11 | 12 | 13 |
14 | 15 | 16 | 17 | 18 | 19 | 20 |
21 | 22 | 23 | 24 | 25 | 26 | 27 |
28 | 29 | 30 |
Tags
- ServletContextInitializer
- 스프링
- @MVC
- spring test mvc
- OAuth2.0
- KSUG
- WebApplicationInitializer
- 스프링시큐리티
- spring security
- Spring Security OAuth
- spring boot mybatis
- spring cloud config
- spring
- Spring MVC
- Spring Boot
- devtools
- mybatis
- spring boot devtools
- 데브툴즈
- spring boot 1.3
- apache thrift
- elasticache
- OAuth 2.0
- Fiilter
- 인텔리J
- Multi DataSource
- spring camp
- 스프링 부트
- spring-mybatis
- spring cloud
Archives
- Today
- Total
홍이의 개발 노트
오라클에서 SQL로 달력 만들기
select min(decode(dd, 1, lvl)) as 일, min(decode(dd, 2, lvl)) as 월, min(decode(dd, 3, lvl)) as 화, min(decode(dd, 4, lvl)) as 수, min(decode(dd, 5, lvl)) as 목, min(decode(dd, 6, lvl)) as 금, min(decode(dd, 7, lvl)) as 토 from (select to_number(to_char(yyyy + level - 1, 'D')) as dd, to_number(to_char(yyyy + level - 1, 'w')) as ww, to_char(yyyy, 'D') as dd1, level as lvl from (select trunc(sysdate,'mm'..
개발이야기/오라클(oracle)
2010. 5. 31. 09:46