INTO

Assigns values from a single row returned by a SELECT statement to scripting variables.

Syntax

SELECT expr1
   [, expr2]
   ...
   [, exprN ]
[INTO :var1]
   [, :var2]
   ...
   [, :varN]
FROM ...
WHERE ...
[...]

Parameters

expr1, expr2 ... exprN: Scalar expressions (e.g., columns from a table specified in the FROM clause).

---

var1, var2 ... varN: Corresponding scripting variables.

Usage Notes

The SELECT statement must return a single row.

Example

DECLARE
  prae STRING;
  post STRING;
BEGIN
  SELECT prefix, suffix INTO :prae, :post
  FROM 
    (SELECT 'META' AS prefix, 'WERK' AS suffix)
  ;
  RETURN :prae || 'KRAFT' || :post;
END;

+---------------+
| return value  |
+---------------+
| METAKRAFTWERK |
+---------------+