Returning a value
With RETURN command you return a value from:
An anonymous block.
A block defined in a stored procedure.
Overview
The values can be returned as a single value of a SQL data type.
sql
[CREATE ... PROCEDURE ... procedure_name()
RETURNS [INTEGER | STRING | TIMESTAMP | DECIMAL]
...]
...
RETURN value;
...Arguments
value: Scalar value of the SQL data type.