How to store a select result in a constant

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.