Oracle standard... table column comment, table comment
밑줄긋고, 빨간색으로 표시된 표식 주목, TAB T, USER_TAB_COMMENTS TC, user_TAB_COLUMNS C, USER_COL_COMMENTS CC SELECT T.TNAME AS TABLE_NAME, TC.COMMENTS AS TABLE_COMMENTS, C.COLUMN_NAME AS COLUMN_NAME, C.DATA_TYPE AS DATA_TYPE, CC.COMMENTS AS COLUMN_COMMENTS FROM TAB T, USER_TAB_COMMENTS TC, user_TAB_COLUMNS C, USER_COL_COMMENTS CC WHERE T.TNAME = TC.TABLE_NAME AND T.TNAME = C.TABLE_NAME AND T.TNAME = CC.TABLE_NA..
2011. 11. 3.
oracle 10g 이상 WM_CONCAT (여러 row 를 한컬럼에)
1. oracle 10g 이상 WM_CONCAT2. 9i때는 xmlelement 등장 oracle 10g 이상 REPLACE (WM_CONCAT (FIELD_NAME), ',', '$') AS COUNT_MAP, oracle 9i 이상 REPLACE (substr( xmlagg(xmlelement(nm,',', FIELD_NAME)).extract('//text()'),2), ',', '$') AS COUNT_MAP oracle 9i 이하 아래 참조.(partition by ,connect by prior 조합.) http://mycup.tistory.com/entry/SQLORACLE-%EC%97%AC%EB%9F%AC-%ED%96%89%EC%9D%98-%ED%8A%B9%EC%A0%95-%EC%BB%AC..
2011. 8. 30.