I have implemented in UiPath a connection with oracle database running a sql query etc.
In order to simplify my question, i want to ask if i can pass somehow in the query a list of strings in the where clause i.e "select a.sr_num, a.* from my_database_table where a.sr_num in (excel column data).
For example, if i needed the query to return the results for sr_num 1-12345, 1-11111 the query would be
select a.sr_num, a.* from my_database_table where a.sr_num in (‘1-12345’, ‘1-11111’).
thanks in advance