Select multiple columns into multiple variables

Your query should be:

SELECT T1.DATE1, T1.DATE2, T1.DATE3INTO V_DATE1, V_DATE2, V_DATE3FROM T1WHERE ID='X';

sql oracle plsql select-into

SELECT    V_DATE1 = T1.DATE1,    V_DATE2 = T1.DATE2,    V_DATE3 = T1.DATE3FROM T1WHERE ID='X';

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

CodeHunter