목록분류 전체보기 (1762)

develog

당월, 전월, 익월

SELECT '201303' THIS_MONTH , DATE_FORMAT(DATE_ADD(STR_TO_DATE('201303', '%Y%m'), INTERVAL -1 MONTH), '%Y%m') PREV_MONTH , DATE_FORMAT(DATE_ADD(STR_TO_DATE('201303', '%Y%m'), INTERVAL 1 MONTH), '%Y%m') NEXT_MONTH ;
DB/MySQL 2013. 3. 6. 11:32
[MySql] 날짜로 조회

-- DATE 컬럼 변형 O SELECT * FROM TABLE_NM WHERE DATE_FORMAT(DATE_COL_NM, '%Y%m%d') = '20130306' ORDER BY DATE_COL_NM ; -- DATE 컬럼 변형 X SELECT * FROM TABLE_NM WHERE 1=1 AND DATE_COL_NM >= STR_TO_DATE('20130306', '%Y%m%d') AND DATE_COL_NM < DATE_ADD(STR_TO_DATE('20130306', '%Y%m%d'), INTERVAL 1 DAY) ORDER BY DATE_COL_NM ;
DB/MySQL 2013. 3. 6. 11:25
rownum, top, limit

--OracleSELECT *FROM TABLE_NMWHERE ROWNUM
DB/DB common 2013. 3. 6. 11:17
jndi test

commons-dbcp-1.4.jar commons-pool-1.6.jar fscontext-4.4.jar ojdbc14.jar import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import javax.naming.Context; import javax.naming.InitialContext; import javax.naming.Reference; import javax.naming.StringRefAddr; import javax.sql.DataSource; public class TestJndi { public static void main(String[] args) { Logger.info..
Dev/Java 2013. 3. 1. 00:36
dbcp test

import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet; import javax.sql.DataSource; import org.apache.commons.dbcp.BasicDataSource; public class TestDbcp { public static void main(String[] args) {Logger.info("START");Logger.info("------------------------------------------------");Connection conn = null;PreparedStatement pstmt = null;ResultSet rs = null;String sql..
Dev/Java 2013. 3. 1. 00:33
Oracle 버전 확인

SELECT * FROM V$VERSION;
DB/Oracle 2013. 2. 27. 13:09
Prev 1 ··· 271 272 273 274 275 276 277 ··· 294 Next