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
- WebApplicationInitializer
- apache thrift
- spring test mvc
- Spring Boot
- 스프링
- spring boot mybatis
- ServletContextInitializer
- 데브툴즈
- spring security
- @MVC
- spring-mybatis
- devtools
- spring boot 1.3
- OAuth2.0
- Multi DataSource
- spring cloud
- OAuth 2.0
- Spring Security OAuth
- mybatis
- elasticache
- Spring MVC
- spring cloud config
- spring boot devtools
- 인텔리J
- spring
- Fiilter
- 스프링 부트
- 스프링시큐리티
- spring camp
- KSUG
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