multiple into in a select statement

[edli]

Hi,

I wanted to select more fields of a select statement into variables, but I saw that this was not possible doing this

select mt.firstfield into var1,mt.secondfield into var2,mt.thirdfield into var3
from my_table mt

How can i do this??

thanks
edli

[jovery]

How about..


SELECT col1, col2
INTO var1, var2
FROM tablename;