Query DB Best practices

Help
1

Good morning everyone,

I am trying to ensure that we use best practices within our UiPath usage. One thing that I wanted to ask is in regards to Queries.

I am currently connecting using an Oracle connection and I can write queries and put the results back into a data table. The problem is tat these queries are hard coded into the Execute Query activity.

I have 2 questions:

1- Is there an easy way to add a query without having to modify the whole thing into one line (the way UiPath likes it ).

2- What is the suggested method of inserting a query into an Execute Query activity within UiPath (a string variable? config file?..etc. )

Thank you