목록분류 전체보기 (1785)

develog

Jacob

http://www.java2s.com/Open-Source/Java/Development/jacob-1.15/com/jacob/Catalogjacob.htm
Dev/Java 2013. 6. 8. 21:12
table 리스트, column 리스트

SELECT *FROM TAB SELECT *FROM COLS
DB/Oracle 2013. 6. 4. 17:29
plsql random

DECLARE V_RET VARCHAR2(100);BEGIN FOR I IN 1..10 LOOP V_RET := DBMS_RANDOM.VALUE(1, 10); DBMS_OUTPUT.PUT_LINE(V_RET); END LOOP;END; // output8.9839078322667001170456974268916958057.851388518184581971599266112831883860421.157766466102041956401705763364660090826.894532276694845208644974061237389197652.924221136847810217187949668093751930521.533997361421105739929250368540803519238.09751621393351335..
DB/PLSQL 2013. 5. 30. 18:31
@Autowired 사용시 셋팅

Dev/Java 2013. 5. 30. 17:37
MERGE INTO

MERGE INTO ATESTUSING DUALON (SEQ = 12)WHEN MATCHED THENUPDATE SETTITLE = 'UPDATE'WHEN NOT MATCHED THENINSERT (SEQ, TITLE)VALUES (12, 'INSERT')
DB/Oracle 2013. 5. 30. 16:00
exception handling

try { // throw exception} catch (Exception e) { logger.error(e.getMessage(), e); throw new RuntimeException(e.getMessage());}
Dev/Java 2013. 5. 29. 15:54
Prev 1 ··· 269 270 271 272 273 274 275 ··· 298 Next