select distinct A.column_name name,A.data_type datatype,A.data_length,
A.data_precision 整数位, A.Data_Scale 小数位,
A.nullable isnullable,c.column_name constraint_name,d.comments tablename,
B.comments comments from user_tab_columns A,user_col_comments B ,all_cons_columns C,USER_TAB_COMMENTS D
where a.COLUMN_NAME=b.column_name and A.Table_Name = B.Table_Name
and A.Table_Name = D.Table_Name and (A.TABLE_NAME=c.table_name) and
A.data_precision 整数位, A.Data_Scale 小数位,
A.nullable isnullable,c.column_name constraint_name,d.comments tablename,
B.comments comments from user_tab_columns A,user_col_comments B ,all_cons_columns C,USER_TAB_COMMENTS D
where a.COLUMN_NAME=b.column_name and A.Table_Name = B.Table_Name
and A.Table_Name = D.Table_Name and (A.TABLE_NAME=c.table_name) and
A.Table_Name=’” + name + “‘
原帖:http://blog.ywxyn.com/index.php/archives/820