IMB System

2015년 3월 10일 화요일

SyntaxHighlighter 3.0.83

Download

http://alexgorbatchev.com/SyntaxHighlighter/download/

Bundled Brushes

Brush name	Brush aliases	File name
ActionScript3	as3, actionscript3	shBrushAS3.js
Bash/shell	bash, shell	shBrushBash.js
ColdFusion	cf, coldfusion	shBrushColdFusion.js
C#	c-sharp, csharp	shBrushCSharp.js
C++	cpp, c	shBrushCpp.js
CSS	css	shBrushCss.js
Delphi	delphi, pas, pascal	shBrushDelphi.js
Diff	diff, patch	shBrushDiff.js
Erlang	erl, erlang	shBrushErlang.js
Groovy	groovy	shBrushGroovy.js
JavaScript	js, jscript, javascript	shBrushJScript.js
Java	java	shBrushJava.js
JavaFX	jfx, javafx	shBrushJavaFX.js
Perl	perl, pl	shBrushPerl.js
PHP	php	shBrushPhp.js
Plain Text	plain, text	shBrushPlain.js
PowerShell	ps, powershell	shBrushPowerShell.js
Python	py, python	shBrushPython.js
Ruby	rails, ror, ruby	shBrushRuby.js
Scala	scala	shBrushScala.js
SQL	sql	shBrushSql.js
Visual Basic	vb, vbnet	shBrushVb.js
XML	xml, xhtml, xslt, html, xhtml	shBrushXml.js

http://alexgorbatchev.com/SyntaxHighlighter/manual/brushes/

추가 옵션 사용법

http://alexgorbatchev.com/SyntaxHighlighter/manual/configuration/

테마

shThemeDefault.css
shThemeDjango.css
shThemeEmacs.css
shThemeFadeToGrey.css
shThemeMidnight.css
shThemeRDark.css

Mybatis 동적쿼리 if 조건이 먹지 않을 때 해결 방법

대상

<if test=" searchUseWhether.equals('') ">

원인

equals('') 부분의 인자값을 String이 아니라 Char로 인식하기 때문에 숫자로 비교된다.

해결

<if test=" searchUseWhether.equals(''.toString()) ">
<if test=" searchUseWhether.equals(&quot;&quot;) ">
<if test=' searchUseWhether.equals("") '>

2015년 3월 2일 월요일

오라클 테이블, 컬럼, 커멘트, 인덱스 등을 조회하는 테이블 정리

오브젝트 조회
ALL_OBJECTS
로그인 유저 테이블 조회
TAB
로그인 유저 테이블 컬럼 조회
USER_TAB_COLUMNS
테이블 조회
ALL_TABLES
테이블 컬럼 조회
ALL_TAB_COLUMNS
컬럼 커멘트 조회
ALL_COL_COMMENTS
인덱스 조회
USER_INDEXES
무결성 조회
USER_CONSTRAINTS
무결성 컬럼 조회
USER_CONS_COLUMNS

-- TABLE LIST

SELECT A.OWNER, A.TABLE_NAME, B.COMMENTS
  FROM ALL_TABLES A
     , ALL_TAB_COMMENTS B
 WHERE A.OWNER      = B.OWNER
   AND A.TABLE_NAME = B.TABLE_NAME
   AND (A.OWNER = 'OWNER1' 
    OR (A.OWNER = 'OWNER2' AND A.TABLE_NAME LIKE 'NAME%'))
 ORDER BY A.OWNER, A.TABLE_NAME
;

-- TABLE COLUMN LIST

SELECT B.OWNER, B.TABLE_NAME, B.COLUMN_ID, B.COLUMN_NAME
     , B.DATA_TYPE
     , B.CHAR_LENGTH
     , B.DATA_PRECISION, B.DATA_SCALE
     , B.DATA_LENGTH
     , B.NULLABLE
     , C.COMMENTS
     , CASE WHEN D.OWNER IS NOT NULL THEN 'PK' END AS PK
  FROM ALL_TABLES A
     , ALL_TAB_COLUMNS B
     , ALL_COL_COMMENTS C
     , ( SELECT F.OWNER, F.TABLE_NAME, F.COLUMN_NAME
           FROM USER_CONSTRAINTS E
              , USER_CONS_COLUMNS F
          WHERE E.OWNER           = F.OWNER
            AND E.CONSTRAINT_NAME = F.CONSTRAINT_NAME
            AND E.CONSTRAINT_TYPE = 'P' ) D
 WHERE A.OWNER       = B.OWNER
   AND A.TABLE_NAME  = B.TABLE_NAME
   AND B.OWNER       = C.OWNER
   AND B.TABLE_NAME  = C.TABLE_NAME
   AND B.COLUMN_NAME = C.COLUMN_NAME
   AND B.OWNER       = D.OWNER (+)
   AND B.TABLE_NAME  = D.TABLE_NAME (+)
   AND B.COLUMN_NAME = D.COLUMN_NAME (+)
   AND (A.OWNER = 'OWNER1' 
    OR (A.OWNER = 'OWNER2' AND A.TABLE_NAME LIKE 'NAME%'))
 ORDER BY B.OWNER, B.TABLE_NAME, B.COLUMN_ID
;