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