查主键名称:
select * from user_constraints
where table_name = 'member'
and constraint_type ='P';
select constraint_name from user_constraints
where table_name = 'member'
and constraint_type ='P';
查主键对应的列:
select * from user_cons_columns
where table_name = 'member'
and constraint_name in ( select constraint_name from user_constraints
where table_name = 'member'
and constraint_type ='P' )