sql - How to write a function in the H2 database without using Java

Question

This question is reference to question "How to create stored procedure using H2 database?" (continuation of the same question).

Is there a way to write a function in H2 without using Java code? My requirement is to translate the functions written in SQL to H2 without using Java code. I found lot of examples in different portals doing the same using Java code. Your help will be greatly appreciated.

Regards Arun

Answer 1

Currently, H2 does only support functions written in Java or a related language (for example Groovy or Scala). PL/SQL (Oracle) and T-SQL (MS SQL Server, Sybase) are not supported.