如何在Oracle PL / SQL中SELECT IN数组数组？

发布时间：2020-12-12 15:12:31 所属栏目：百科来源：网络整理

导读：我正在尝试在数组中保存一组ID： declare cities_ids array_of_numbers;beginselect id into cities_ids from objects where id = 1115464; FOR i IN 1..cities_ids.COUNT LOOP DBMS_OUTPUT.PUT_LINE(cities_ids(i)); END LOOP;end; 执行后,我遇到下一个错误

我正在尝试在数组中保存一组ID：

declare
 cities_ids array_of_numbers;
begin
select id into cities_ids from objects where id = 1115464;
    FOR i IN 1..cities_ids.COUNT LOOP
        DBMS_OUTPUT.PUT_LINE(cities_ids(i));
    END LOOP;
end;

执行后,我遇到下一个错误：

ORA-00932: inconsistent datatypes. Expected UDT,got NUMBER.

请说明我做错了什么

很简单：BULK COLLECT缺少.

declare
 cities_ids arrayofnumbers;
begin
select object_id BULK COLLECT into cities_ids from nc_objects where object_id = 1000;
    FOR i IN 1..cities_ids.COUNT LOOP
        DBMS_OUTPUT.PUT_LINE(cities_ids(i));
    END LOOP;
end;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!