select cu.*,au.* from user_cons_columns cu,
user_constraints au
where cu.constraint_name = au.constraint_name
andau.constraint_type = 'P' and au.table_name = 'JGS_TDGY'(表名)select cu.*,au.* from user_cons_columns cu,
user_constraints au
where cu.constraint_name = au.constraint_name
andau.constraint_type = 'P' and au.table_name = 'JGS_TDGY'(表名)