Re: Implicit vs. Explicit cursors

In article <8h1jf5$4ad$1_at_nnrp1.deja.com>,   tedchyn_at_yahoo.com wrote:
> thomas, the performance of explict and implicit cursor are about the
> same, so reusability of sql is not a issue as described by kenneth.
> ?
> ted

the reusability is sql is limited by the use of bind variables (or lack thereof -- thats why I thought he might be mixing the 2 concepts).

Implicit cursors can and will be reused as are explicit cursors. In plsql -- I always go for implicit cursors myself.

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.