일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
- Tomcat
- Exception
- 오픈소스
- IntelliJ
- error
- AJAX
- Eclipse
- Open Source
- JavaScript
- SpringBoot
- Core Java
- maven
- spring
- ubuntu
- git
- Docker
- myBatis
- MSSQL
- STS
- Spring Boot
- 문서
- 설정
- MySQL
- Source
- PostgreSQL
- Python
- oracle
- JDBC
- jpa
- Thymeleaf
- Today
- Total
목록2016/04 (4)
헤르메스 LIFE
연속된 날짜 생성 쿼리 -- 시작일('20130101'), 종료일('20130110') SELECT TO_DATE('20111201', 'YYYY-MM-DD') + LEVEL - 1 AS DATES FROM DUAL CONNECT BY LEVEL
중복기간 체크 SELECT CASE WHEN EXISTS ( SELECT 1 FROM CHECK_TABLE WHERE KEY0 = 'KEY0' AND KEY1 = 'KEY1' AND STA_YMD '시작일' AND STA_YMD = '시작일' ) THEN 'Y' ELSE 'N' END DUP_YN FROM DUAL
-- 전일 SELECT TO_CHAR(SYSDATE - 1, 'YYYYMMDD') FROM DUAL; -- 현재주 SELECT TO_CHAR(SYSDATE, 'WW') FROM DUAL; -- 지난주 SELECT TO_CHAR(SYSDATE -7, 'WW') FROM DUAL; -- 현재월 SELECT TO_CHAR(SYSDATE, 'YYYYMM') FROM DUAL; -- 현재분기 SELECT TO_CHAR(SYSDATE, 'q') FROM DUAL; -- 반기 SELECT CEIL(TO_CHAR(SYSDATE, 'q') / 2) FROM DUAL;
출처 : http://www.edankert.com/validate.html Configure Java APIs (SAX, DOM, dom4j, XOM) using JAXP 1.3 to validate XML Documents with DTD and Schema(s).Many Java XML APIs provide mechanisms to validate XML documents, the JAXP API can be used for most of these XML APIs but subtle configuration differences exists. This article shows five ways of how to configure different Java APIs (including DOM, S..