I have two tables emp and dept .
Dept table has one column called depno and the values are 10,30,40.
I have used following query
[code=oracle]
Declare
v_empno number ;
v_ename name;
v_sal ;
cursor c1 is select deptno from dept ;
begin
for r1 in c1
loop
select empno,ename,sal into v_empno,v_ename ,v_sal from emp
where deptno=r.deptno ;
end loop;
end;
/
[/code]
but i am getting below error as
ORA-01422: exact fetch returns more than requested number of rows
cud u please advice .
Thanks
Dept table has one column called depno and the values are 10,30,40.
I have used following query
[code=oracle]
Declare
v_empno number ;
v_ename name;
v_sal ;
cursor c1 is select deptno from dept ;
begin
for r1 in c1
loop
select empno,ename,sal into v_empno,v_ename ,v_sal from emp
where deptno=r.deptno ;
end loop;
end;
/
[/code]
but i am getting below error as
ORA-01422: exact fetch returns more than requested number of rows
cud u please advice .
Thanks
Comment