The APEX_ITEM package enables users to create form elements dynamically based on a SQL query instead of creating individual items page by page.
For a complete description of this package within the context of APEX, see APEX_ITEM in the Oracle Application Express API Reference.