Hello experts,
May I ask for your help?
I have tables like this: COMP_REL(PARENT NUMBER, CHILD NUMBER ...) and COMP_INFO(CHILD NUMBER, ...).
In a procedure, I need to make several select statements from COMP_INFO for all children under a parent (grouping by different columns of COMP_INFO).
The problem is that COMP_REL table is huge. How can I use PLSQL collection(or array) to store the children of COMP_REL that I need and then join this collection with COMP_INFO to get the different data?
Is it a good practice to use PLSQL collections for this purpose at all?
Thank you, Atanas.