Learn how to use the LIMIT clause with BULK COLLECT. Manage PGA memory consumption efficiently when processing millions of rows.