H2 Database – Call

CALL is a SQL command which belongs to the H2 database server. This command is used to calculate a simple expression. It returns the result of the given expression in a single column field. When it returns an array of results, then each element in the array is displayed as a column value.

Syntax

Following is the generic syntax of the CALL command.

CALL expression;

We can use the arithmetic expression in this syntax.

Example

Let us take an example and execute an arithmetic expression (15 * 25) using the call command.

CALL 15*25; 

The above command produces the following output.

375
375

Leave a Reply