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