Arvid Regenberg

@kunzel_paulo Hi. I'm afraid there is a technical error in the article. It is written that the collection data is stored in RAM and not in a physical table. As far as i know, collection data is stored in 2 tables in the APEX schema. (WWV_FLOW_COLLECTIONS$, WWV_FLOW_COLLECTION_MEMBERS$).

Checkout my latest post #orclapex #oracle #plsql #sql

@PHoinkis commit;

☺ #married

@PHoinkis @plamen_9 In addition, I would possibly add the CASE to the ORDER BY clause to more precisely express what the CASE stands for. This would also allow the MIN(id) to still be used.

@plamen_9 Hey Plamen, is there a reason why you used first_value and not min? I assume that min would be faster in this case.

I came across an interesting task today ⚡️ The dataset below (part of Employees table) had to be sorted by Department and then by Last Name and First Name. One extra requirement is that the Employee with lowest Id has to be on top of each Department. Thread below 🧵 Page 1/6