where在需要下列之一时declarevidnumber:=&id;vstockcountnumber;beginselectstockcountintovstockcountfromesproduct;whereid=vid;dbmsoutputline(vstocount);end;

Question

where 在需要下列之一时
declare
v_id number := &id;
v_stock_count number;
begin
select stockcount into v_stock_count from es_product;
where id = v_id;
dbms_output_line(v_stocount);
end;

Answer 1

你把where上一行行尾的分号去掉就Ok了