我想在一个Oracle脚本中使用变量,如下:
declare
vary number(10);
user varchar(20);
begin
select a.value into vary from table1 a where rownum <=1;
dbms_output.put_line('a.value = ' || vary); select b.name into user
from table2 b
where b.value = vary;
end;
但是执行不了;报错 ora-01422 实际返回的行数超出请求的行数请问我怎么在select中使用这个vary变量?
declare
vary number(10);
user varchar(20);
begin
select a.value into vary from table1 a where rownum <=1;
dbms_output.put_line('a.value = ' || vary); select b.name into user
from table2 b
where b.value = vary;
end;
但是执行不了;报错 ora-01422 实际返回的行数超出请求的行数请问我怎么在select中使用这个vary变量?
from table2 b
where b.value = vary;
返回的行数超过一行,所以出错