difference between imlicit cursor and explicit cursor ?
Answers were Sorted based on User's Feedback
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 |
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 |
implicit: it is generating by sql server.
explicit: it is generating by user.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kiran
implicit generated by oracle server
explicit manually created by programmer to store the result
in the temporary space
Is This Answer Correct ? | 0 Yes | 0 No |
implicit cursor is a memory space created by oracle..and
explicit cursor is named memory area
Is This Answer Correct ? | 0 Yes | 1 No |
What are the database administrators utilities available?
Can we call a trigger inside a function and function inside a trigger? Give example.
What is the difference between pre-select and pre-query?
what is the difference between first normal form & second normal form?
What privilege is needed for a user to create views in oracle?
What is clustered table in Oracle?
Is oracle an operator?
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
How to write a left outer join with the where clause in oracle?
How to display row numbers with the records?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
How many types of database triggers exist?