select * from Table T
where T.field > TO_DATE(:3,'MM/DD/YYYY HH24:MI:SS')
Field is not in graph.
This is a low priority demand
this is about "simplifier precedence" . TO_DATE(:3,'MM/DD/YYYY HH24:MI:SS') gets reduced to **TO_DATE(:3) -> TO_DATE() -> empty instead of being reduced to :3.
Looks that :3 should be an identifier (not simplified ) rather than a constant
Not sure, :bind is a constant.
I suspect simplifier behavior
Select * from T
a='DD-MM-YYYY' that is wrong too.
Well, there are two constant parameters. One constant is dropped. Than the function itself is dropped, leaving one constant. Unfortunately, the remaining constant it is not the one you wanted to see. In general, one cannot say that first parameter is more important than the second.
One solution would be to drop the function with several parameters and subtitute it with it's parameters. Of course, as long as the function is not aggregation function
Exception is caused by inteprteting several columns as one -> there are too many dots
With Oracle, first parameter in a function is most of the time the value, others are formats or replacement values.
As always there are a few exceptions as concat, greatest, …