你这是等着把你写好啊。

select a.OWNER,A.TABLE_NAME,A.COLUMN_NAME,a.DATA_TYPE,b.comments,decode(d.CONSTRAINT_TYPE,'P','是','否') primary_,decode(f.info2,1,'是','否') identity_
from ALL_TAB_COLUMNS a
left join ALL_COL_COMMENTS b on a.OWNER=b.OWNER and a.TABLE_NAME=b.TABLE_NAME and a.COLUMN_NAME=b.COLUMN_NAME
left join all_CONS_COLUMNS c on a.OWNER=c.OWNER and a.TABLE_NAME=c.TABLE_NAME and a.COLUMN_NAME=c.COLUMN_NAME
left join all_CONSTRAINTS d on c.OWNER=d.OWNER and c.TABLE_NAME=d.TABLE_NAME and c.constraint_name=d.constraint_name
left join SYSOBJECTS e on a.TABLE_NAME=e.name
left join syscolumns f on e.id=f.id and a.COLUMN_NAME=f.name
where a.owner='SYSDBA' and a.TABLE_NAME='TEST1'