Is it possible to declare variable inside Query Console?

Answered
Avatar
Adilet Murzaliev
Created

Is it possible to declare variable, somehow like this and then use it in every queries (so we don't need to put value every time on parameter dialog):

SET/VAR/DECLARE (any style) ${someValue} = 5;
select * from table1 where field1 < ${variable};
select * from table1 where field1 < ${variable} and ...;

Votes

9

Share

3 comments
Avatar
Yuriy Vinogradov
Created

We have user parameters, which can be used in query like

select *
from public.actor
where actor.actor_id < ${a}

and when you run such query you'll get prompted to enter a value for 'a'. And there is no limit for variable count of course. So no need to declare everything before. If you will use 'a' multiple times in a query - there will be only one request to enter value.

Syntax like

declare variable STRING;
set variable = "hell";
select variable;

is supported for BigQuery, MS SQL, Sybase, HSQL, Exasol, DB2.

1
Avatar
Bert
Created

the feature would definitely be helpful for relational databases as well

0
Avatar
Bert
Created

or maybe a UI-only solution where you can define multiple parameter sets (as sketched here) would already be sufficient

2

Please sign in to leave a comment.