Skip to Main Content

Oracle Forms

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How execute_query Works in Oracle Forms

MWaseemNov 23 2020

Hi Gurus,
Please guide me how did execute_query works. Did it uses bulk collect to fetch all records from database or it fetches one row at a time in single call.
What would be more fast and will use less resources from database.
bulk collect using PLSQL OR Native Execute Query.

This post has been answered by Michael Ferrante-Oracle on Nov 23 2020
Jump to Answer
Comments
Post Details
Added on Nov 23 2020
4 comments
7,737 views