SQL> set serveroutput on SQL> declare 2 v number; 3 begin 4 select 1 into v from dual; 5 dbms_output.put_line(v) ; 6 end; 7 / 1PL/SQL procedure successfully completed.
如何作为条件来做?如: declare v int; begin select 1 into v from dual; select * from table where a=v; end; 上面这段代码总报错说“第六行select语句缺少into子句”
如何作为条件来做?如: declare v int; begin select 1 into v from dual; select * from table where a=v; --你这句sql肯定是不行的,或者用游标吧 都是select col into bl from tb ,再去看看基础方面书吧 end;
select * from table where a=v; 这样是不行的哟! 你可以用游标。 cursor my_cur is select * from table where a=v;
要先定义变量 declare 变量名 变量类型; begin select 1234 into 变量名 from dual; end;
1234和变量类型相同?1234是数字
SQL> declare
2 v number;
3 begin
4 select 1 into v from dual;
5 dbms_output.put_line(v) ;
6 end;
7 /
1PL/SQL procedure successfully completed.
declare
v int;
begin
select 1 into v from dual;
select * from table where a=v;
end;
上面这段代码总报错说“第六行select语句缺少into子句”
如何作为条件来做?如:
declare
v int;
begin
select 1 into v from dual;
select * from table where a=v;
--你这句sql肯定是不行的,或者用游标吧
都是select col into bl from tb ,再去看看基础方面书吧
end;
select * from table where a=v;
这样是不行的哟!
你可以用游标。
cursor my_cur is select * from table where a=v;
declare
变量名 变量类型;
begin
select 1234 into 变量名 from dual;
end;