difference between imlicit cursor and explicit cursor ?

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / nagireddyunix

5 Answers
8351 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

difference between imlicit cursor and explicit cursor ?..

Answer / vsubbaiah

Implicit : Every SQL Statement performed as implicit cursor. Ex: Select * from Emp where empno = 7839 This is query automatically open the cursor and fetch the record getting the output of that record.

Explicit : In PLSql Block in we declare on declaration section we declare with name and select statement. In executable block we call the cursor and fetch the records more the one. For Ex : Declare
cursor c1 is select * from emp
getemp c1%rowtype;
begin
open c1;
loop
fetch c1 into getemp;
dbms_output.put_line (c1.col list);
end loop;
close c1;
end; This is explicit cursor

Is This Answer Correct ?

4 Yes

0 No

difference between imlicit cursor and explicit cursor ?..

Answer / vipin kumar ( m.c.a)

1. Implicit cursor:- means predefine cursor. Its attributes
starting with the sign % like that %ROWCOUNT, %ISOPEN etc.
2. Explicit cursor:- means created by the user or
programmer. Its attributes starting with the cursor name
then % sign lick that cursorname%ROWCOUNT, cursorname%ISOPEN
etc.

Is This Answer Correct ?

0 Yes

0 No

difference between imlicit cursor and explicit cursor ?..

Answer / harsha vardhan reddy

implicit: it is generating by sql server.

explicit: it is generating by user.

Is This Answer Correct ?

0 Yes

0 No

difference between imlicit cursor and explicit cursor ?..

Answer / kiran

implicit generated by oracle server

explicit manually created by programmer to store the result
in the temporary space