qq_41273205的博客

查询表的主键列名称 SELECT tt.table_name, listagg (tt.column_name, ',') WITHIN GROUP (ORDER BY tt.table_name) as pk FROM ( SELECT uc.table_name, ucc.column_name FROM user_constraints uc, user_cons_columns ucc, user_indexes ui WHERE uc.tab