不好意思,更正一下第4---7段程序,应是下面这样:
4.--在3的基础上加了一个变量申明,但没有用到此变量,出错;
declare
v_name my_table.name%type;
begin
select my_table.classname from my_table;
end;
5.--在4的基础上在查询语句里用到了该变量,OK
declare
v_name my_table.name%type;
begin
select my_table.classname into v_name from my_table;
end;
6.--OK
declare
v_id my_table.id%type:=1;
v_name my_table.name%type;
begin
select my_table.classname into v_name from my_table
where my_table.id = v_id;
end;
7.--我不需要v_name变量,但,出错;
declare
v_id my_table.id%type:=1;
begin
select my_table.classname from my_table
where my_table.id = v_id;
end;
4.--在3的基础上加了一个变量申明,但没有用到此变量,出错;
declare
v_name my_table.name%type;
begin
select my_table.classname from my_table;
end;
5.--在4的基础上在查询语句里用到了该变量,OK
declare
v_name my_table.name%type;
begin
select my_table.classname into v_name from my_table;
end;
6.--OK
declare
v_id my_table.id%type:=1;
v_name my_table.name%type;
begin
select my_table.classname into v_name from my_table
where my_table.id = v_id;
end;
7.--我不需要v_name变量,但,出错;
declare
v_id my_table.id%type:=1;
begin
select my_table.classname from my_table
where my_table.id = v_id;
end;
楼上的能不能详细点,意思是说在pl/sql中只要不是全部用非标准的sql,比如declare,begin,...就得into出来,对吗???
select 是需要into
v_emp emp%ROWTYPE;
BEGIN
SELECT * INTO v_emp FROM EMP;
END;