The APEX_ITEM package enables users to create form elements dynamically based on a SQL query instead of creating individual items page by page.

Documentation of APEX_ITEM

For a complete description of this package within the context of APEX, see APEX_ITEM in the Oracle Database Application Express User's Guide.