SELECT A.TABLE_NAME,
A.NUM_ROWS,
B.COMMENTS,
D.COLUMN_NAME,
D.POSITION
FROM ALL_TABLES A left outer join ALL_TAB_COMMENTS B on B.OWNER=A.OWNER AND B.TABLE_NAME=A.TABLE_NAME
left outer join ALL_CONSTRAINTS C on C.OWNER=B.OWNER AND C.TABLE_NAME=A.TABLE_NAME
left outer join ALL_CONS_COLUMNS D on D.OWNER=C.OWNER AND D.CONSTRAINT_NAME=C.CONSTRAINT_NAME
WHERE A.OWNER='SCOTT' AND
C.CONSTRAINT_TYPE='P'
ORDER BY A.TABLE_NAME,D.POSITION
A.NUM_ROWS,
B.COMMENTS,
D.COLUMN_NAME,
D.POSITION
FROM ALL_TABLES A left outer join ALL_TAB_COMMENTS B on B.OWNER=A.OWNER AND B.TABLE_NAME=A.TABLE_NAME
left outer join ALL_CONSTRAINTS C on C.OWNER=B.OWNER AND C.TABLE_NAME=A.TABLE_NAME
left outer join ALL_CONS_COLUMNS D on D.OWNER=C.OWNER AND D.CONSTRAINT_NAME=C.CONSTRAINT_NAME
WHERE A.OWNER='SCOTT' AND
C.CONSTRAINT_TYPE='P'
ORDER BY A.TABLE_NAME,D.POSITION
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货