|
-
As Davey says, why not try some benchmarking and find out.
It depends on a number of factors, but generally the implicit cursor will be faster.
'Select into' used to be almost frowned upon, maybe that is where the developer is coming from.
It's much easier to interpret:
select field1 into variable1 from table1;
than
cursor cursor1 is
select field1
from table1;
begin
open cursor1;
fetch cursor1
into variable1;
close cursor1;
I know which one I'd rather read.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|