Hi,
As I understand them, dynamic queries allow me to replace placeholders with strings / numbers.
Is there a way to use dynamic queries for serialized data?
Example:
SELECT * FROM table WHERE param in (‘value1’, ‘value2’, ‘value3’, ‘value4’)
Now say I wanted this query to be dynamic, how would I do that? It would require enabling me to use a placeholder in those paranthesis and allowing me to submit an array as the value for the placeholder. Example:
SELECT * FROM table WHERE param in ({my_values})
Submitting: p_my_values = [“value1”, “value2”, “value3”, “value4”]
Thanks.