Oracle function “TO_NUMBER” not supported in H2 database

Question

Function TO_NUMBER is in a H2 roadmap for 1.4.x as priority 2. But in the last version 1.4.196 it's still not supported. Can anyone tell me, in what version can I expect support for this function?

Answer 1

As a workaround, execute this SQL to create the function:

CREATE ALIAS TO_NUMBER AS $$
Long toNumber(String value) {
    return value == null ? null : Long.valueOf(value);
}
$$;