Skip to Main Content
  • Questions
  • Question from USER399341 for Database In-Memory Office Hours - 2021-11-24

Breadcrumb

Question and Answer

Thanks for the question.

Asked: November 23, 2021 - 10:50 pm UTC

Last updated: November 23, 2021 - 10:50 pm UTC

Version:

Viewed 100+ times

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