difference between imlicit cursor and explicit cursor ?
Answer Posted / 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 |
Post New Answer View All Answers
What is redo log?
What is the difference between Delete, Truncate and Drop in Oracle?
What are the different types of synonyms?
How to grant create session privilege to a user in oracle?
6. Display the client name and order date for all orders using the traditional method.
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How to create a table in a specific tablespace?
How to write a query with an inner join in oracle?
How to write date and time interval literals in oracle?
Explain oracle instance.
What is instant client oracle?
How to drop an index in oracle?
What is data file?
What is the exact use of Collections?
What is a nvl function?