摘要:
一、select * from all_tab_cols A where lower(A.Table_Name) = '表名称';二、select b.TABLE_NAME 表名,c.comments 表评论,b.COLUMN_ID 字段信号,b.COLUMN_NAME 字段名,b.DATA_LENGTH 数据长度,b.DATA_PRECISION 整数位,b.DATA_SCALE 小数位,a.comments 列描述from all_col_comments a,all_tab_columns b,all_tab_comments cwhere a.table_name=b.TABLE_NA 阅读全文