[Oracle]取得資料表欄位,型態,長度等資訊

SELECT
  C.OWNER, C.TABLE_NAME, C.COLUMN_ID, C.COLUMN_NAME,
  DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_DEFAULT,
  NULLABLE, COMMENTS
FROM
  ALL_TAB_COLUMNS C
JOIN ALL_TABLES T ON
  C.OWNER = T.OWNER AND C.TABLE_NAME = T.TABLE_NAME
LEFT JOIN ALL_COL_COMMENTS R ON
  C.OWNER = R.Owner AND
  C.TABLE_NAME = R.TABLE_NAME AND
  C.COLUMN_NAME = R.COLUMN_NAME
where C.OWNER=:p0 AND C.TABLE_NAME =:p1
ORDER BY C.TABLE_NAME, C.COLUMN_ID

:p0=>資料庫名稱
:p1=>所要找尋的Table名稱

感謝黑暗執行緒無私的分享
參考網址如下:
http://goo.gl/3kHVbL