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