查询表的所有列及其属性：selectt.*,c.COMMENTS from user_tab_columnst,user_col_commentsc where t.table_name = c.table_name and t.column_name = c.column_name and t.table_name = women;查找表的主键：select cu.* from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = 'P' a
