Menu

#4 Oracle Cast and (+)

open
nobody
None
5
2012-12-07
2011-03-04
substrash
No

Currently CAST expressions are not supported and makes the parser fail because CAST(a1 AS DATE) does not satisfy the grammar.
Currently the Oracle outer join (+) is not supported and makes the parser fail.

It would be great if queries like:

select t1.a12 a, decode(t2.a22, null, '0', '1') as b, cast(t3.a31 as date) c
from t1, t2 join t3
where t1.a11(+) = t2.a21

could be parsed, even better if they could be interpreted to a certain extent.

Discussion

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.