Re: implicit / explicit?

An implicit cursor (prior to Oracle 8) was less efficient than an explicit cursor.

implicit example

select 'x'
into [bind variable]
from dual;

This causes two network trips, once to get the data and once to check if there is any more data (to return the TOO_MANY_ROWS error)

explicit example

cursor c1 is
select 'x'
from dual;
begin
open c1;
fetch c1 into [bind variable]
close c1;
end;

This will cause one network round trip, because it is explicitly controlled by the open/fetch/close syntax.

However, in Oracle8, this does not apply (I think :) as array fetches are executed.

Regards

--
===
---------------------------------------------------
Jason Pepper  Phone Mail : +44 171 691 7298
                Fax Mail : +44 171 691 7298
                  E-Mail : jason_at_steamer.u-net.com
                     WWW : www.steamer.u-net.com
   -- Smile, fresh air is good for the teeth --
Richard Fairbairn wrote in message <1998032618194776740_at_zetnet.co.uk>...


>Can someone please tell me what the difference is between an implicit

>variable and an explicit variable? Ditto for cursors?

>

>Help!

>

>Best wishes

>

>

>R.W. Fairbairn

>