You Asked
The following question was asked, but got attached to the Nov 24th session which was re-scheduled to this Nov 18th session:
Question from USER399341 for
Database In-Memory Office Hours - 2021-11-24
I have a Table with all transaction amounts (both +ve and -ve amount). I have to find a combination of these amounts that equate to a given sum transaction amount stored in another table. There will be 10s of thousands of transactions int he first table. I am using Oracle 19c. Appreciate your help.
and we said...
I'm not sure I understand this question, but I think the intent is would it be possible to create an In-Memory Expression to materialize the amounts? There is a restriction that the value must be deterministic so I would suggest that you contact me directly so that I can get more details.
Regards, Andy
Is this answer out of date? If it is, please let us know via a Comment