Interested to Buy Any Domain ? << Click Here >> for more details...
difference between imlicit cursor and explicit cursor ?
- 5 Answers
- 9372 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
write a query that displays every Friday in a year with date?
can a table has a column that has only view data and in other columns we can change data?
Is oracle a language?
How to get last row id?
What is a public synonym?
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
How to start a specific oracle instance?
What is translate in oracle?
What is dual table oracle?
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
Oracle General 
