SELECT t.table_name, c.column_name
FROM dba_cons_columns c
JOIN dba_constraints con ON c.constraint_name = con.constraint_name
JOIN (
SELECT table_name, owner
FROM dba_tables
WHERE owner = 'CNDCDATA'
) t ON con.table_name = t.table_name AND con.owner = t.owner
WHERE con.constraint_type = 'P'
ORDER BY t.table_name, c.position;
04-19
04-18
281
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
07-27
5610
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
08-25
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交