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 is Reduced List of Values?
Can the default values be assigned to actual parameters?
Difference between varchar and varchar2 data types?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
What is a nested table?
Point out the difference between user tables and data dictionary?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
how to store only time in a data base table
Which dictionary tables and/or views would you look at to diagnose a locking issue?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How can I get column names from a table in oracle?