Select multiple columns into multiple variables

Question

How can I do in one select with multiple columns and put each column in a variable?

Something like this:

--code here
V_DATE1 T1.DATE1%TYPE;
V_DATE2 T1.DATE2%TYPE;
V_DATE3 T1.DATE3%TYPE;

SELECT T1.DATE1 INTO V_DATE1, T1.DATE2 INTO V_DATE2, T1.DATE3 INTO V_DATE3
FROM T1
WHERE ID='X';

--code here

Paolo Forgia · Accepted Answer · 2017-10-11 07:22:45Z

180

Your query should be:

SELECT T1.DATE1, T1.DATE2, T1.DATE3
INTO V_DATE1, V_DATE2, V_DATE3
FROM T1
WHERE ID='X';

edited Oct 11, 2017 at 7:22

Paolo Forgia

6,7568 gold badges51 silver badges60 bronze badges

answered Aug 7, 2013 at 16:57

Bob Jarvis - Слава Україні

50.2k10 gold badges81 silver badges119 bronze badges

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

Comments

Bruno Peres · Accepted Answer · 2018-07-30 20:21:14Z

2

SELECT
    V_DATE1 = T1.DATE1,
    V_DATE2 = T1.DATE2,
    V_DATE3 = T1.DATE3
FROM T1
WHERE ID='X';

I had problems with Bob's answer but this worked fine

edited Jul 30, 2018 at 20:21

Bruno Peres

16.5k6 gold badges57 silver badges92 bronze badges

answered Jul 19, 2018 at 3:04

Gerard

3012 silver badges10 bronze badges

Collectives™ on Stack Overflow

Select multiple columns into multiple variables

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related