Re: SELECT INTO

You have to define the variable first in which you are going to select the column of particular record. But this is good to access only one record.

You use it as follows
Declare
MyVariable

Begin
select salary into MyVariable from Employee;

End;
/
Where Salary being the column name & Employee table name. But if you have more than one records it's going to give you error. Unless you are trying to access particular record using where command.

kev wrote in message <3912E803.F12298AF_at_fast.no>...
>Hi,
>
>How do I use SELECT INTO?
>
>I couldn't find an explanation on Oracle's site, please could someone
>give me a URL.
>
>thanks,
>
>- Kev
>
Received on Fri May 05 2000 - 00:00:00 CDT