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