oracle 如何检查数组是否包含特定字符串？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14578316/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to check if an array contains a particular string?
提问by user1394523
I have an array of strings. I want to check if a particular string is present in the array.
我有一个字符串数组。我想检查数组中是否存在特定字符串。
DECLARE
TYPE v_array IS TABLE OF VARCHAR2(200);
ais_array v_array;
BEGIN
ais_array := ('Lb1','Lb2','Lb3','Lb613');
IF 'Lb1' IN ais_array THEN
dbms_output.put_line('found');
END IF;
END;
The INoperator is not working. I tried doing a select *on the type and then using INbut that didn't work either.
该IN运营商不工作。我尝试select *在类型上做一个然后使用，IN但这也不起作用。
Any suggestions?
有什么建议？
回答by Egor Skriptunoff
Try member ofcondition:
试用member of条件：
IF 'Lb1' member of ais_array THEN
dbms_output.put_line('found');
END IF;
Oracle introduced several set operators for working with collections in 10g. Please read the documentation to learn more.
Oracle 在 10g 中引入了几个集合操作符来处理集合。请阅读文档以了解更多信息。
回答by dfortun
MEMBER OF can only be used with nested tables. You're trying to use it on an associative array. You are going to get an error "wrong number or types of arguments in call to 'MEMBER OF' ".
MEMBER OF 只能用于嵌套表。您正试图在关联数组上使用它。您将收到错误消息“调用 'MEMBER OF' 的参数数量或类型错误”。
This is how to use it:
这是如何使用它：
DECLARE
TYPE clientele IS TABLE OF VARCHAR2 (64);
client_list_12 clientele := clientele ('Customer 1', 'Customer 2');
client_list_13 clientele := clientele ('Customer 1', 'Customer 3');
client_list_133 clientele
:= clientele ('Customer 1', 'Customer 3', 'Customer 3');
client_list_empty clientele := clientele ();
BEGIN
IF 'Customer 1' MEMBER OF client_list_12
THEN
DBMS_OUTPUT.put_line ('Customer 1 is in the 12 list');
END IF;
IF 'Customer 2' NOT MEMBER OF client_list_13
THEN
DBMS_OUTPUT.put_line ('Customer 2 is not in the 13 list');
END IF;
DBMS_OUTPUT.put_line ('List 133 contains ' || CARDINALITY (client_list_133) || ' items');
IF client_list_empty IS EMPTY
THEN
DBMS_OUTPUT.put_line ('Client list is empty');
END IF;
IF client_list_133 IS NOT EMPTY
THEN
DBMS_OUTPUT.put_line ('Client list 133 is not empty');
END IF;
END;
