查询表结构

SELECT A.OWNER,A.TABLE_NAME,A.COLUMN_NAME,A.DATA_TYPE,A.DATA_LENGTH,B.COMMENTS FROM (
SELECT OWNER, TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, NULLABLE
  FROM ALL_TAB_COLUMNS
 WHERE TABLE_NAME = ‘table_name’

 ORDER BY COLUMN_ID) A
LEFT JOIN (
SELECT * FROM ALL_COL_COMMENTS WHERE TABLE_NAME = ‘table_name’) B
ON A.TABLE_NAME = B.TABLE_NAME AND A.COLUMN_NAME = B.COLUMN_NAME