Difference between an implicit & an explicit cursor.?
Answers were Sorted based on User's Feedback
Answer / v.ramesh
Implicit cursor is taken care by oracle server only,when we write any statement or query in the SQL editor,in that case oracle server create some memory for that and do operation on that query and finally erase the space as well
in case of Explicit cursor,manually like we need to create the Cursor and open.fetch the data and close the cursor.
we have one more alternative for this,if we will create cursor we need to user FOR LOOP mechanism in this case all exlicit cursor are not needed i.e OPEN<FETCH<CLOSE
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / basanti
IMPLICIT CURSOR: When we execute any sql statement, PL/SQL creates implicit cursor and manages automatically means implcit open & close takes place. It used when sql statement return only one row.
It has 4 attributes SQL%ROWCOUNT, SQL%FOUND, SQL%NOTFOUND, SQL%ISOPEN.
EXPLICIT CURSOR: It is created & managed by the programmer. It needs every time explicit open,fetch & close.
It is used when sql statement returns more than one row.
It has also attributes CUR_NAME%ROWCOUNT, CUR_NAME%FOUND, CUR_NAME%NOTFOUND, CUR_NAME%ISOPEN.
Is This Answer Correct ? | 0 Yes | 0 No |
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
how to find out second largest value in the table
Please explain joins in oracle?
What is meant by raw datatype?
How to export your connection information to a file?
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
What are the types of trigger in oracle?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to write numeric literals in oracle?
What is sequence?