1,可以参考正面的语句
SQL> select b.owner,a.constraint_type,a.table_name,b.column_name
2 from USER_CONSTRAINTS a, USER_CONS_COLUMNS b
3 where a.constraint_name = b.constraint_name and a.constraint_type ='P';OWNER CONSTRAINT_TYPE TABLE_NAME COLUMN_NAME
------ --------------- ------------- --------------
HR P REGIONS REGION_ID
HR P COUNTRIES COUNTRY_ID
HR P LOCATIONS LOCATION_ID
HR P DEPARTMENTS DEPARTMENT_ID
HR P JOBS JOB_ID
HR P EMPLOYEES EMPLOYEE_ID
HR P JOB_HISTORY EMPLOYEE_ID
HR P JOB_HISTORY START_DATE8 rows selected2,应该是指primary key的顺序吧,3,个人认为可以通过查找dba_tables中的owner字段,区分表所归属的用户来达到区分是系统表还是用户表。
SQL> select b.owner,a.constraint_type,a.table_name,b.column_name
2 from USER_CONSTRAINTS a, USER_CONS_COLUMNS b
3 where a.constraint_name = b.constraint_name and a.constraint_type ='P';OWNER CONSTRAINT_TYPE TABLE_NAME COLUMN_NAME
------ --------------- ------------- --------------
HR P REGIONS REGION_ID
HR P COUNTRIES COUNTRY_ID
HR P LOCATIONS LOCATION_ID
HR P DEPARTMENTS DEPARTMENT_ID
HR P JOBS JOB_ID
HR P EMPLOYEES EMPLOYEE_ID
HR P JOB_HISTORY EMPLOYEE_ID
HR P JOB_HISTORY START_DATE8 rows selected2,应该是指primary key的顺序吧,3,个人认为可以通过查找dba_tables中的owner字段,区分表所归属的用户来达到区分是系统表还是用户表。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货