SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Are Explicit Cursors better than Select Statement

289018Jul 11 2002

Hi Gurus,
I came across this opinion that explicit cursors are better (even if the query returns a single row) instead of a single row SELECT statement within the code in terms of performance.

Is that true??? Pls elaborate in either case.

Can i hear it from Sri/Andrew ???
Thanks for ur time...

Peyush

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 19 2002

Added on Jul 11 2002

47 comments

3,214 views