oracle变量赋值有两种一种是直接:=还有就是select into declare v_1 number:=0;----也可以在变量定义后赋值 begin v_1:=23; select count(*) into v_1 from emp; end;