我有两个表,分别是SCOMPANY_TEMP和clientinfo 我想查找一下在SCOMPANY_TEMP表的name列中是否存在clientinfo 表中的scompanyname对应的信息,为此我写了如下存储过程可是总是不对,请高手给我指导一下,或者您帮我写一个,谢谢: as
begin
declare
CURSOR c_emp IS
select name from SCOMPANY_TEMP;
emp_rec c_emp%rowTYPE;
begin
OPEN c_emp;
LOOP
FETCH c_emp INTO emp_rec;
select scompanyname from clientinfo where scompanyname like '''%'||emp_rec.name||'%''';
EXIT WHEN c_emp%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(emp_rec.name);
end loop;
close c_emp;
end;
end;
begin
declare
CURSOR c_emp IS
select name from SCOMPANY_TEMP;
emp_rec c_emp%rowTYPE;
begin
OPEN c_emp;
LOOP
FETCH c_emp INTO emp_rec;
select scompanyname from clientinfo where scompanyname like '''%'||emp_rec.name||'%''';
EXIT WHEN c_emp%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(emp_rec.name);
end loop;
close c_emp;
end;
end;
行号= 11 列号= 3 错误文本= PLS-00428: an INTO clause is expected in this SELECT statement
CURSOR c_emp IS
select a.* from SCOMPANY_TEMP a ,clientinfo where scompanyname like '%'||a.name||'%';
emp_rec c_emp%rowTYPE;
begin
OPEN c_emp;
LOOP
FETCH c_emp INTO emp_rec;
EXIT WHEN c_emp%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(emp_rec.name);
end loop;
close c_emp;
end;