Memory Analyzer Heap Dump생성하는 명령어

jmap -heap:format=b 프로세스ID

CSS로 둥근 모서리 구현하기

<style>
.rtop, .rbottom{display:block; background: #FFFFFF;}
.rtop *, .rbottom *{display: block; height: 1px; overflow: hidden; background: #9BD1FA;}
.r1{margin: 0 5px}
.r2{margin: 0 3px}
.r3{margin: 0 2px}
.r4{margin: 0 1px; height: 2px}
</style>
<div id="container" style="background: #9BD1FA">
<b class="rtop">
<b class="r1"></b> <b class="r2"></b> <b class="r3"></b> <b class="r4"></b>
</b>
<p>
CSS로 둥근 모서리 구현하기</p>
<b class="rbottom">
<b class="r4"></b> <b class="r3"></b> <b class="r2"></b> <b class="r1"></b>
</b>
</div>

css div,pre,p,span 자동 개행

pre, p, div, span {

white-space: pre-wrap; /* css-3 */

white-space: -moz-pre-wrap; /* Mozilla, since 1999 */

white-space: -pre-wrap; /* Opera 4-6 */

white-space: -o-pre-wrap; /* Opera 7 */

word-wrap: break-word; /* Internet Explorer 5.5+ */

}

split함수 사용시 고려 사항.

split할때 \\를 사용해야 하는 문자 : |, * (TODO... 더 추가 해야함..)

 

ex) 파일 자르기 샘플...

  String fileInfo = "201011011114596711864229111*____.xml*    XML Document*D:/ProjectSource/jkd5/SEL-CPS/fileUpCPS/20101101111459_04451417237.000*16144|";
 
  // 파일 명을 자른다.
  String [] file_infos = fileInfo.split("\\|");

  System.out.println(" file_infos.length --> " + file_infos.length );
  ==>  file_infos.length --> 1

 

  for( int i=0 ; i<file_infos.length  ; i++ ) {
   file_info_es = file_infos[i].split("\\*");
   
   System.out.println(" file_info_es.length --> " + file_info_es.length);
   for( int j=0 ; j<file_info_es.length; j++ ) {
    System.out.println( j + ":" + file_info_es[j]);
   }
  } 

 ==>

 file_info_es.length --> 5
0:201011011114596711864229111
1:____.xml
2:    XML Document
3:D:/ProjectSource/jkd5/SEL-CPS/fileUpCPS/20101101111459_04451417237.000
4:16144

PROCEDURE GOTO

IF SOME_CHECK THEN

     GOTO END_OF_THIS;

END IF;

 

로직들....

<<END_OF_THIS>>

일괄 ALTER 스크립트

SELECT 'ALTER TABLE '||TABLE_NAME||' MODIFY '||COLUMN_NAME||' NUMBER(5);'
       , 'UPDATE '||TABLE_NAME||' SET  '||COLUMN_NAME||' = NULL;'
       , TABLE_NAME , (SELECT COMMENTS FROM ALL_TAB_COMMENTS WHERE OWNER = B.OWNER AND TABLE_NAME = B.TABLE_NAME ) TABLE_COMMENTS
       , B.DATA_TYPE, B.DATA_LENGTH
  FROM ALL_TAB_COLUMNS B
WHERE OWNER = 'USER_NAME'
  AND ( COLUMN_NAME LIKE '%COLUMN_NAME' OR COLUMN_NAME LIKE '%COLUMN_NAME' ' )
  AND TABLE_NAME LIKE 'C%'
  AND TABLE_NAME NOT LIKE '%DIA_SQ%'

GRANT

grant select on 시퀀스명 to USER명;

 

 

SELECT 'GRANT SELECT ON '||TNAME||'  TO 유저명;'

    FROM TAB;