SELECT * FROM user_tables A WHERE NOT EXISTS ( SELECT * FROM user_constraints b WHERE A .table_name = b.table_name AND b.constraint_type = 'P' );
转自：http://bbs.csdn.net/topics/300243837
SELECT * FROM user_tables A WHERE NOT EXISTS ( SELECT * FROM user_constraints b WHERE A .table_name = b.table_name AND b.constraint_type = 'P' );
转自：http://bbs.csdn.net/topics/300243837
