Question

oracle约束查询语句

Answer 1

select * from user_constraints where constraint_name = '约束名称'

或者将表名换成dba_constraints，
这个是查询所有的约束，而user_constraints是查询当前用户所拥有的约束的。

Answer 2

用desc名如desc user_constraints 查看结构然后选择查询的内容
下面三个是常用的...
select * from user_constraints;
select * from all_constraints ;
select * from dba_constraints ;

Answer 3

select * from user_constraints where constraint_name = '约束名称'