번호출력값사용방법 0 Feb 22 2006 4:26PM CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) 1 02/22/06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1) 2 06.02.22 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2) 3 22/02/06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3) 4 22.02.06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 4) 5 22-02-06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 5) 6 22 Feb 06 CONVERT(CHAR(9), CURRENT_TIMESTAMP, 6) 7 Feb 22, 06 CONVERT(CHAR(..

> javap -verbose 네놈이버전을알고싶은클래스네임 | find/N "version" minor version: 0 major version: 50 빨간줄에 숫자를 주목!! 48: java 1.4.2 49: java 5 50: java 6

SELECT TO_CHAR(SYSDATE,'YYYY"년" MM"월" DD"일"') FROM DUAL; 이거 뭐 완죤 날로먹내;;;;;;

1. oracle sys 접속 C\>sqlplus /nolog SQL>conn /as sysdba; 2. 한글설정 properties update SQL>update sys.props$ set value$='KO16MSWIN949' where name='NLS_CHARACTERSET'; SQL>update sys.props$ set value$='KO16MSWIN949' where name='NLS_NCAHR_CHARACTERSET'; SQL>update sys.props$ set value$='AMERICAN_AMERICA.KO16MSWIN949' where name='NLS_LANGUAGE'; SQL>commit; SQL>shutdown immediate; 3. DATABASE charset 변경 S..

import java.security.MessageDigest; public class Hash { private static MessageDigest md5 = null; static { try { md5 = MessageDigest.getInstance("MD5"); } catch (java.security.NoSuchAlgorithmException e) { e.printStackTrace(); } } public Hash() {} public String getHashValue(String value) { byte[] md = md5.digest(value.getBytes()); StringBuffer sb = new StringBuffer(); for (int i = 0; i < md.lengt..

숫자 제거 : TRANSLATE('대상문자열', ' +.0123456789', ' ') SELECT TRANSLATE('abc1def2', ' +.0123456789', ' ') FROM DUAL == > abcdef