Can any body explain me the exact difference between these two operations “SELECT” & “SELECT(One Record)”.
The JDBC adapter documentation says :
“Use the SELECT (One Record) operation to configure a SELECT operation that returns only one record.”
I assume that it is the same for Oracle adapter.
Therefore, operation output will be a single record/struct instead of an array.