盡人事待天命

미디어협동조합 국민TV
select round(dbms_random.value(0,100),2) from dual
Posted by 톰켓 Trackback 0 Comment 0
SELECT A.COLUMN_NAME,COMMENTS FROM ALL_TAB_COLUMNS A, ALL_COL_COMMENTS B
WHERE A.OWNER=B.OWNER
AND A.TABLE_NAME=B.TABLE_NAME
AND A.COLUMN_NAME=B.COLUMN_NAME


위의 쿼리를 활용하면 잘 나온다...
Posted by 톰켓 Trackback 0 Comment 0
 select sql_text from v$sqlarea

이렇게 치면 이력이 나온다 ㅋㅋ


Posted by 톰켓 Trackback 0 Comment 0

cmd > tasklist.exe /FI "IMAGENAME eq java.exe"

java 프로세스아이디를 얻어낼수있다.

cmd > jps.exe -v
java 프로세스아이디를 얻어낼수 있다.
또한 어떤 cmd로 실행되었는지 알수 있음.

cmd > jstack ${pid}

해당 java 프로세스 의 stack trace 를 얻어낸다...

cmd > jstack ${pid} > stacktrace.txt 

리다이렉션을 이용하면 . txt 파일로 저장가능..


Posted by 톰켓 Trackback 0 Comment 0

SimpleDateFormat Thread Issue

http://forum.java.sun.com/thread.jspa?threadID=497693&messageID=2906187

This is certainly not a foolproof solution, and I
think synchronizing the parse() and fomat() methods
are adjusting the timing enough to reduce the
occurences of the exception being thrown. Again, in
my code the parse() call is only ever made from a
single thread.

SimpleDateFormat & Thread
http://crosscutter.info/2

Posted by 톰켓 Trackback 0 Comment 0
function show(where,type,name,script,limit,num){
 var element='';
 for(var x=0 ; x<num ; x++){
  if(limit<=x)break;
  element+="<input type='"+type+"' name='"+(name+x)+"' "+script+"><br>";
 }
 document.getElementById(where).innerHTML = element;
}
Posted by 톰켓 Trackback 0 Comment 0
function KTF(where,type,name,script,limit,num){
 var element='';

  element+="<input type='"+type+"' name='"+(name+x)+"' "+script+"><br>";

 document.getElementById(where).innerHTML = element;
}

 


Posted by 톰켓 Trackback 0 Comment 0
하는 방법은 알아서 ^^


jxl.jar파일입니다..

찾아보시면 다 잘나와 있죠
Posted by 톰켓 Trackback 0 Comment 0
  SELECT  /*+ index(a pk_${LIST_TABLE}) */ 
    ERROR_CODE AS CURRENT_CODE
  FROM ${LIST_TABLE} a
  WHERE POST_ID='${POST_ID}'
  AND  MEMBER_ID='${M_ID}'

SELECT /*+ INDEX DESC (A.IDX) */ 
FROM TAB1 A
WHERE 부서번호 = 'B1'
Posted by 톰켓 Trackback 0 Comment 0
   select tname from tab
Posted by 톰켓 Trackback 0 Comment 0


티스토리 툴바