How to store a unique query RESULT into DBeaver variable?

Question

i'm trying to store some data in Dbeaver binding variables like these:

--test
@set test = good
--testQ
@set testQ = select date from table where id = 1;

I need to store the query result, NOT the query statment, someone knows if this is posible?

I have tried many things and have had no success. Also very interested in an answer. — Marquee
– Marquee, Commented Jul 8, 2022 at 20:40

Luciano Gonçalves · Accepted Answer · 2023-06-19 19:10:01Z

0

try this:

@set testQ = (select date from table where id = 1)

select * from anotherTable where date = :testQ;

It is important not use ; in variable declaration, because will duplicate the command finalization

answered Jun 19, 2023 at 19:10

3054 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

i don't think this works. unfortunately dbeaver variables only seem able to do basic find-replace of text