Select A.COLUMN_NAME COLUMN_NAME, B.COMMENTS, decode(A.DATA_TYPE,'DATE',A.DATA_TYPE, 'NUMBER',decode(A.DATA_SCALE,0,A.DATA_TYPE||'('||a.DATA_PRECISION||')', A.DATA_TYPE||'('||a.DATA_PRECISION||','||A.DATA_SCALE||')'), A.DATA_TYPE||'('||a.DATA_LENGTH||')' ) DATA_TYPE
From USER_TAB_COLS A ,
(
Select * From (Select a.*,row_number() over(partition By column_name order by comments) rn From( Select Distinct COLUMN_NAME,COMMENTS
From USER_COL_COMMENTS
Order By COLUMN_NAME DESC,COMMENTS Nulls Last ) a ) Where rn=1
) B
Where A.COLUMN_NAME=B.COLUMN_NAME And lower(A.TABLE_NAME) =lower('v_tran_aai02') Order By a.COLUMN_ID
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11419868/viewspace-1012081/ ，如需转载，请注明出处，否则将追究法律责任。
