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 | 31 |
Tags
- spring-mybatis
- OAuth 2.0
- spring cloud
- spring test mvc
- Fiilter
- Spring Security OAuth
- 스프링
- KSUG
- spring boot mybatis
- 데브툴즈
- 스프링 부트
- Spring MVC
- spring boot 1.3
- 스프링시큐리티
- elasticache
- Multi DataSource
- spring cloud config
- @MVC
- spring boot devtools
- Spring Boot
- spring
- spring security
- mybatis
- apache thrift
- ServletContextInitializer
- WebApplicationInitializer
- spring camp
- devtools
- OAuth2.0
- 인텔리J
Archives
- Today
- Total
목록SQL (1)
홍이의 개발 노트
오라클에서 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