HELP - SELECT...INTO Variable ---> More than one variable???

[Reshmi Jacob]

Hello

Can I have more than one variable assign to a select clause in a trigger. How? My stmt creates an error

SELECT FLD1 into VAR1, FLD2 into VAR2 FROM MYTABLE;

ERROR shown at the second INTO.

I tried to make it a cursor and it was successful .

But I would like to know if its possible or any other method???

Thanks & Regards
Reshmi

[milonov]

Hi, Reshmi.

You did all correct. select into is suitable for only one variable and cursor if more then one.

Best Regards,
Michael Milonov

http://www.snotratech.com

Hello

Can I have more than one variable assign to a select clause in a trigger. How? My stmt creates an error

SELECT FLD1 into VAR1, FLD2 into VAR2 FROM MYTABLE;

ERROR shown at the second INTO.

I tried to make it a cursor and it was successful .

But I would like to know if its possible or any other method???

Thanks & Regards
Reshmi

[suvam]

U can try with it -----------
Select field1,field2 into v1,v2 from t1 ;

[pragatiswain]

U can try with it -----------
Select field1,field2 into v1,v2 from t1 ;

Suvam is right

[ltiongECT]

You can also do something like (SQLServer):

declare @variable1 varchar(75)
declare @variable2 varchar(75)

select @variable1 = FirstName, @variable2 = LastName from Employees
where...

Note: if you query returns multiple row, your variables will take on the value of the last row.

[amitpatel66]

You can also do something like (SQLServer):

declare @variable1 varchar(75)
declare @variable2 varchar(75)

select @variable1 = FirstName, @variable2 = LastName from Employees
where...

Note: if you query returns multiple row, your variables will take on the value of the last row.

This Syntax is not supported in Oracle!!