07-31-2023, 09:06 AM
SQL Server developers consider Cursors a bad practise , except under some circumstances. They believe that Cursors do not use the SQL engine optimally since it is a procedural construct and defeats the Set based concept of RDBMS.
However, Oracle developers do not seem to recommend against Cursors. Oracle's DML statements themselves are implicit cursors.
Why this difference in approach? Is it because of the way these 2 products are made, or does this advice apply to both products?
However, Oracle developers do not seem to recommend against Cursors. Oracle's DML statements themselves are implicit cursors.
Why this difference in approach? Is it because of the way these 2 products are made, or does this advice apply to both products?