通过SEARCH_CONDITION查询查找约束 [英] Query to find Constraint by SEARCH_CONDITION

问题描述

我想在SEARCH_CONDITION中找到Oracle中的CONSTRAINT_NAME。

  SELECT * FROM ALL_CONSTRAINTS 
 WHERE TABLE_NAME = myTableName'; 
 AND SEARCH_CONDITION ='myColumnIS NOT NULL'; 
  

ORA-00997：非法使用LONG数据类型。

如何通过SEARCH_CONDITION查询？

解决方案

SEARCH_CONDITION是长期的，因此您不能使用....非常有用。

对于这种特殊用法，我建议PLSQL例程将LONG col写入VARCHAR2（32767），然后对VARCHAR2变量应用检查。 / p>

LONG是绝对的痛苦。

此外，您可以通过查询ALL_CONS_COLUMNS WHERE column_name ='colname'，并加入ALL_CONSTRAINTS以获取SERACH_CONDITION。

I want to find a CONSTRAINT_NAME in Oracle by SEARCH_CONDITION.

SELECT * FROM ALL_CONSTRAINTS
WHERE TABLE_NAME = 'myTableName';
AND SEARCH_CONDITION = '"myColumn" IS NOT NULL';

ORA-00997: illegal use of LONG datatype.

How to query by SEARCH_CONDITION?

解决方案

SEARCH_CONDITION is LONG so you can't use it for .... very much useful.

For this particular use, I suggest PLSQL routine to write the LONG col into a VARCHAR2(32767) and then apply the check on teh VARCHAR2 variable.

LONGs are an absolute pain.

Also, in your case you can restrict the dataset further by querying ALL_CONS_COLUMNS WHERE column_name = 'colname' and joining the ALL_CONSTRAINTS to get the SERACH_CONDITION.

这篇关于通过SEARCH_CONDITION查询查找约束的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！