Question:
State the difference between implicit and explicit cursor's.
Answer:
Implicit Cursor are declared and used by the oracle internally. whereas the explicit cursors are declared and used by the user. more over implicitly cursors are no need to declare oracle creates and process and closes autometically. the explicit cursor should be declared and closed by the user. Source: CoolInterview.com
Implict cursor can be used to handle single record (i.e) the select query used should not yield more than one row. if u have handle more than one record then Explict cursor should be used. Source: CoolInterview.com
Answered by: Dinesh | Date:
| Contact Dinesh
It is not mandatory that when the query retrieves more than one record then explicit cursor should be used. If the number of records is less than 100 then implicit cursor should be used. e.g. set serverout on; begin for i in (select * from emp) loop dbms_output.put_line(i.empno); end loop; end; / Source: CoolInterview.com
Answered by: Sukhamoy | Date: 10/6/2007
| Contact Sukhamoy
Cursor: It is automatically created by oracle for all sql dml statements including the query that returns one row.
Explicit cursor: These are created and managed by the user.And used for multi row select statement. Source: CoolInterview.com
Answered by: josu | Date: 2/25/2008
| Contact josu
Implicit cursors are oracle created and used internally by oracle,the only implicit cursor is sql.
Explicit cursors are user created cursors. Source: CoolInterview.com
Answered by: Ashish | Date: 11/7/2009
| Contact Ashish
Cursors are used for the purpose of storing the intermediate results when executing a SQL Query or a block of code... Implicit Cursors are by default declared by ORacle itself and hence there is no scope of storing resultset with more than one record where as Explicit Cursors are declared by the User and hence can define the parameters with measure to store the no of records. Source: CoolInterview.com
Answered by: DurgaMadhuri | Date: 12/6/2009
| Contact DurgaMadhuri
Cursors opened by oracle engine for its internal proceesing are known as implicit cursors. A user can also open a cursor for processing data as required. User defined cursor are known as Explicit cursor. Source: CoolInterview.com
Answered by: santhosh | Date: 5/7/2010
| Contact santhosh
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|