Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between an implicit & an explicit cursor.?
- 2 Answers
- 7268 Views
- I also Faced
- E-Mail Answers
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 |
Does oracle charge for java?
What are the execution control statements?
Explain constraining triggers.
Please explan Why static query is more faster than dynamic query ?
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
What is an anonymous block?
How translate command is different from replace?
What is a SNAPSHOT ?
How to select some rows from a table in oracle?
What is Public Database Link ?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
How you open and close a cursor variable.Why it is required?
Oracle General 
