begin

for x in (select * from emp) loop

.........................................;

................................;

end loop;

end;

Just tell me which type of cursor that is being used in the above example?

Is explicit or implicit?

Ref:- sidharth

for x in (select * from amp)

loop

..................................;

...............................;

end loop;

is an explicit cursor.

hello

i think this is an implicit cursor.

pavani.

No vandana

that is explicit cursor

pavani

actually in that programme selection statement having * that is why that is explicit cursor.

thank you

kamal

Implicit cursor will select and return only (only) one row

like :

select ename job into v_ename v_job

from emp

where empno 7839;

Explicit cursor can have one row or multiple

like in previous example its explicit because statement may return more then one row.

another example for explict cursor:

declare

cursor c1 is select ename job sal from emp;

v_ename emp.ename type;

v_job emp.job type;

v_sal emp.sal type;

begin

open c1;

loop

fetch c1 into v_ename v_job v_sal;

exit when c1 notfound;

dbms_output.put_line(v_ename||' '|v_job||' '||v_sal);

end loop;

end;

/

No that is implicit cursor

coz it is used in begin part