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