How to store a select result in a constant

This question is not really clear.

Can you give an example of what you mean?

Hi,

Do you want to store the statement or part of it and use it in a SQL-Creator/Executor?

You can simply create the statement or part of it (or an entire query) in a attribute.

Assemble your query in the SQL-Creator/Executor using the previously created attribute(s).

(basically a "pseudo dynamic query" using fme. Much easier then true dynamic query using oracle)

Just be aware that you cannot populate with pseudo dynamic queries. ( you will have to use a non dynamic to populate (a simple select * will do) it and then replace the query with the dynamic version).

But if you want to store a select statement or part of it, and access this using oracle sql, you can if you store it in excel/txt and then access the excel/txt trough oracle.