박광용

이번에 Spring, IBatis, GWT 프로젝트를 시작합니다 .

그래서 이번에 블로그로 제작과정을 올려보려고 하는데, 평소에 소스검색하다가 간간히 syntaxhighlighter로 소스를 기제해놓은 블로그들이 많더군요... 그래서 이번에 적용했습니다.

인터넷에 방법올라온 사이트 중 아래 사이트가 샨새교 블로그에 적용시키는 방법을 잘 기제해놨더군요~~~

이렇게 올릴준비도해놨구 했는데... 잘 배워서 올릴수있으려나... 에휴... 너무 어렵다 Spring~

http://mainia.tistory.com/313 

SELECT X.TABLE_NAME TABLE_ID, 


(SELECT COMMENTS FROM USER_TAB_COMMENTS WHERE TABLE_NAME = X.TABLE_NAME) TABLE_NM, 


X.COLUMN_NAME FIELD_ID, 


(SELECT COMMENTS FROM USER_COL_COMMENTS WHERE TABLE_NAME = X.TABLE_NAME AND COLUMN_NAME = X.COLUMN_NAME) FIELD_NAME, 


X.DATA_TYPE AS "TYPE", 


DECODE(X.DATA_TYPE, 'DATE', NULL, 'BLOB', NULL, 


X.DATA_LENGTH || CASE WHEN X.DATA_PRECISION IS NOT NULL THEN ',' || X.DATA_SCALE END ) DATATYPES, 


CASE WHEN SUBSTR(Y.INDEX_NAME, 1, 2) = 'PK' THEN 'PK' 


ELSE DECODE(X.NULLABLE, 'N', 'NOT NULL', '') END "NOT NULL", 


X.DATA_DEFAULT 


FROM COLS X, USER_IND_COLUMNS Y 


WHERE X.TABLE_NAME = Y.TABLE_NAME(+) 


AND X.COLUMN_NAME = Y.COLUMN_NAME(+) 


ORDER BY X.TABLE_NAME, X.COLUMN_ID 

NIKON CORPORATION | NIKON D80 | Manual | Center-weighted average | 1/200sec | F/3.5 | +0.67 EV | 200.0mm | ISO-500 | Flash fired, auto mode, return light detected | 2009:04:12 10:48:51

더보기

NIKON CORPORATION | NIKON D80 | Manual | Center-weighted average | 1/250sec | F/2.8 | +0.33 EV | 100.0mm | ISO-640 | Flash did not fire | 2009:04:12 13:06:04

NIKON CORPORATION | NIKON D80 | Manual | Center-weighted average | 1/200sec | F/3.5 | +0.33 EV | 105.0mm | ISO-500 | Flash fired, auto mode, return light detected | 2009:04:12 10:44:08

NIKON CORPORATION | NIKON D80 | Manual | Center-weighted average | 1/200sec | F/2.8 | +0.33 EV | 80.0mm | ISO-640 | Flash fired, auto mode, return light detected | 2009:04:12 12:40:23

NIKON CORPORATION | NIKON D80 | Manual | Center-weighted average | 1/200sec | F/2.8 | +0.33 EV | 120.0mm | ISO-640 | Flash fired, auto mode, return light detected | 2009:04:12 12:42:22

NIKON CORPORATION | NIKON D80 | Manual | Center-weighted average | 1/250sec | F/2.8 | +0.33 EV | 135.0mm | ISO-640 | Flash did not fire | 2009:04:12 13:03:42

NIKON CORPORATION | NIKON D80 | Manual | Center-weighted average | 1/200sec | F/2.8 | +0.33 EV | 105.0mm | ISO-640 | Flash fired, auto mode, return light detected | 2009:04:12 15:48:42

NIKON CORPORATION | NIKON D80 | Manual | Center-weighted average | 1/200sec | F/2.8 | +0.33 EV | 135.0mm | ISO-640 | Flash fired, auto mode, return light detected | 2009:04:12 15:48:47

 

NIKON CORPORATION | NIKON D80 | Manual | Center-weighted average | 1/200sec | F/2.8 | +0.33 EV | 105.0mm | ISO-640 | Flash fired, auto mode, return light detected | 2009:04:12 15:48:42

사진 보기

NIKON CORPORATION | NIKON D80 | Manual | Center-weighted average | 1/200sec | F/2.8 | +0.33 EV | 165.0mm | ISO-640 | Flash fired, auto mode, return light detected | 2009:04:12 15:49:40

NIKON CORPORATION | NIKON D80 | Manual | Center-weighted average | 1/200sec | F/2.8 | +0.33 EV | 130.0mm | ISO-640 | Flash fired, auto mode, return light detected | 2009:04:12 15:50:55

NIKON CORPORATION | NIKON D80 | Manual | Center-weighted average | 1/200sec | F/2.8 | +0.33 EV | 175.0mm | ISO-640 | Flash fired, auto mode, return light detected | 2009:04:12 15:58:43