M
M
marselabdullin2020-10-28 20:13:04
Oracle
marselabdullin, 2020-10-28 20:13:04

Is it possible to get a formula from a string, unpack it and apply it?

Now I will try to explain normally)
To begin with, I will attach a screen for understanding (I immediately apologize for the photo and the quality could not otherwise):
5f99a4ede8644260114905.jpeg

The gosb_id, tb_id, org_id fields from the group_level table store the name of the fields from the erp_trips table not visible on the screenshot), also group_level.formula stores the formula as a string. And all these fields should be perceived by the select not as strings, but as values ​​(so that the fields are taken from erp_trips, and the formula is executed) This was

done in order not to repeat hundreds of the most similar selects.
any options.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question