如题,望高手指点
解决方案 »
- oracle10g新增的日志文件如何激活?
- ORACLE11安装错误,请大伙告诉我是那里出错了?
- oracle存储过程基础问题
- 关于数据库的问题
- 求大家给一些有关oracle存储过程的资料与例子详解。
- ORA-06502: PL/SQL: 数字或值错误 ORA-06512: 在line 1
- noresetlogs and resetlogs区别
- 怎么写序号生成器(Number (8)),又怎么在SQL的Insert中调用?
- 高分请教关于在使用javamail实现在oracle里发送邮件附件的功能!
- export数据库大于4G时突然挺下来了,请问为什么?
- c#及数据库的高手帮帮忙
- 紧急求救,列转行问题
具体看约束在哪一列,就关联dba_cons_columns查看。
SELECT C.CONSTRAINT_NAME,
CC.COLUMN_NAME,
CC.POSITION,
C.OWNER,
C.TABLE_NAME
FROM ALL_CONSTRAINTS C, ALL_CONS_COLUMNS CC
WHERE C.OWNER = CC.OWNER
AND C.CONSTRAINT_TYPE = 'P'
AND C.CONSTRAINT_NAME = CC.CONSTRAINT_NAME
AND C.TABLE_NAME = CC.TABLE_NAME
ORDER BY 4, 1, 3;
select * from user_constraints
where table_name = 'KWHDATA200807'
and constraint_type ='P';
select constraint_name from user_constraints
where table_name = 'KWHDATA200807'
and constraint_type ='P';
查主键对应的列:
select * from user_cons_columns
where table_name = 'KWHDATA200807'
and constraint_name in ( select constraint_name from user_constraints
where table_name = 'KWHDATA200807'
and constraint_type ='P' )