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.
senthil
Jul 26th, 2006
Any other differences
Suresh
Jul 28th, 2006
More over Explicit Cursors were used to retrieve values from two or more rows.
gouthami kodangal
Aug 13th, 2006
implicit cursors are definfined by the oracle server whenever the operations are on single row where as for operations on mutiple rows the programmer declare cursors explisitly.
SP
Feb 9th, 2007
Every Select statement is an implicit cursor. As others have said, you do not need to worry about how the rows are managed. In explicit cursors you can do further work while looping. There is a better chance that the Explicit cursor statement is cached to a better extent that the implicit cursor statement, therefore the more times you run it (the explicit cursor) the better the performance gets.
Implicit cursors are faster and result in much neater code so there are very few cases where you need to resort to explicit cursors.
Implicit cursors are declared by PL/SQL implicitly for all DML and PL/SQL SELECT statements, including queries that return only one row. Explicit cursors for queries that return more than one row, explicit cursors are declared and named by the programmer and manipulated through specific statements in the block’s executable actions.
PL/SQL uses two types of cursors: implicit and explicit. PL/SQL declares a cursor implicitly for all SQL data manipulation statements, including queries that return only one row. However, for queries that return more than one row, you must declare an explicit cursor, use a cursor FOR loop, or use the BULKCOLLECT clause.
KSPRADEEEP
Oct 17th, 2012
Cursors are two types (1) Implicit cursor and (2) Explicit cursor
Implicit cursors are Oracle predefined cursors. It will automatically open,fetch and close the cursor respectively.It will returns only one record at a time. If you want return more than one record it will raise error .Too_many_rows.
Explicit cursors are user-defined cursors.If we use explicit cursor user need to open,fetch and close the cursor by using explicit cursor we can return more than one records..
The main difference between Implicit and Explicit cursors is by using implicit we can execute only record where as Explicit returns more than one records. implicit cursor is do open the cursor and fetching data and closing cursor where as Explicit is User defined user needs open cursor and fetching data and close the cursor.
VASU
Oct 20th, 2012
Implicit cursors returns only single record..where as explicit cursor multiple records. But it process record by record.
chiatanya
Nov 5th, 2012
Implicit cursors are automatically generated,when a sql statement is processed where as
State the difference between implict and explict cursor's