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 are group functions in oracle?
What is the purpose of save points in oracle database?
What is the database name in oracle?
Explain a private synonyms?
How to retrieve data from an cursor to a record?
How to recover a dropped table in oracle?
How to check the server version in oracle?
What are the different types of modules in oracle forms?
State all possible different index configurations a table can possibly have?
When do you get a .pll extension in oracle?
What are privileges and grants?
What is meant by recursive hints in oracle?
Is java required for oracle client?
What are the predefined tablespaces in a database?
What is a user role in oracle?