select column_name from user_constraintsc,user_cons_columnscol where c.constraint_name=col.constraint_name and c.constraint_type='P' and c.table_name='acctinfo'
查找表的主键(包括名称,构成列):select cu.* from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name and au.constraint_type = 'P' and au.table_name = 'acctin