table集合,指的是pl sql表还是数据库表 aa.column_value中的任意一个值赋给变量BB => select column_value into bb from aa where rownum<2
for aa in (select column_value from table(ppdiv(name, ',')) where not exists (select 1 from table1 t1 where t1.name = column_value)) loop想实现aa的任意一个值赋予一个变量bb end loop说明:ppdiv是一个拆分字符串的方法,name是一个字符串
select column_value into bb (select column_value from table(ppdiv(name, ',')) where not exists (select 1 from table1 t1 where t1.name = column_value) order by dbms_random.value) where rownum<2
declare bb varchar2(100); begin select column_value into bb from aa; dbms_output.put_line('变量BB的值:'||bb); end;
--任意一个 declare bb varchar2(100); begin select column_value into bb from aa where rownum<=1; dbms_output.put_line('变量BB的值:'||bb); end;
aa.column_value中的任意一个值赋给变量BB
=>
select column_value into bb from aa where rownum<2
where not exists (select 1 from table1 t1
where t1.name = column_value))
loop想实现aa的任意一个值赋予一个变量bb
end loop说明:ppdiv是一个拆分字符串的方法,name是一个字符串
(select column_value from table(ppdiv(name, ','))
where not exists (select 1 from table1 t1
where t1.name = column_value)
order by dbms_random.value)
where rownum<2
bb varchar2(100);
begin
select column_value into bb from aa;
dbms_output.put_line('变量BB的值:'||bb);
end;
declare
bb varchar2(100);
begin
select column_value into bb from aa where rownum<=1;
dbms_output.put_line('变量BB的值:'||bb);
end;