Skip to main content

set

1. SET Function​

The SET function in H2 database is used to set the value of a variable or parameter within a SQL statement.

2. Syntax​

The syntax for the SET function in H2 database is as follows:

SET variable = value

Arguments​

  • variable: The name of the variable or parameter that needs to be set.
  • value: The value to be assigned to the variable or parameter.

Return​

  • The SET function does not return any value.

3. Notes​

  • The SET function in H2 database allows you to set the value of variables or parameters within a SQL statement.
  • The variables or parameters can be used later in the same SQL statement or in subsequent statements.
  • It is important to note that the SET function is specific to H2 database and may not be available in other database systems.

4. Examples​

Here are a few examples demonstrating the usage of the SET function in H2 database:

Example 1 - Setting a variable within a SQL statement:​

SET @name = 'John';

SELECT 'Hello, ' || @name AS greeting;

Output:

greeting
---------------
Hello, John

Example 2 - Setting a parameter within a SQL statement:​

SET @age = 25;

SELECT * FROM users WHERE age > @age;

Output:

id | name  | age
---+-------+-----
1  | John  |  30
2  | Alice |  28

There are no directly related functions to the SET function in H2 database. However, you can use variables or parameters set by the SET function in other SQL statements or functions within the same session.