SELECT ROWNUM 序号,A.COLUMN_NAME AS"字段名称",B.comments AS"字段描述",
A.DATA_TYPE as 字段类型,REPLACE(DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_PRECISION||','||A.DATA_SCALE),A.CHAR_LENGTH),',0','') 字段长度,REPLACE(REPLACE(A.NULLABLE,'Y','√'),'N','')AS"能否为空",
A.DATA_DEFAULT AS"默认值"FROM sys.all_tab_columns A,sys.DBA_COL_COMMENTS B
WHERE A.owner=B.owner AND A.table_name=B.table_name AND A.COLUMN_NAME=B.COLUMN_NAME AND A.owner='用户名'AND
A.TABLE_NAME IN('TB_MT_CONVENIENCE_APP')ORDERBY A.TABLE_NAME