Select multiple columns into multiple variables June 30, 2023 by Tarik Your query should be: SELECT T1.DATE1, T1.DATE2, T1.DATE3 INTO V_DATE1, V_DATE2, V_DATE3 FROM T1 WHERE ID='X';