select substr(d.
from dual d
will not work (empty list) until closing parenthesis is added
like:
select substr(d. )
from dual d
You and others have reported this a lot and the answer remains the same. The closing paren requirement is a well discussed shortcoming. It’s logged as part of a larger syntax recovery feature for the parser and there’s no ETA.
MIchael, every now and then this works (or gets fixed to some extent) - that’s why I raise it again.
Generally speaking the unclosed paren will fail always. It might work OK if present after the FROM clause because the parser can find the table references before it encounters the unmatched paren and can parse no more. In the SELECT list I’ve not seen a case where it ever works. I’d just assume that it will not.