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