PL-SQL Noobie

Do you know how to do this T-SQL in PL-SQL, namely, move a single record query result columns into local variables?

BEGIN DECLARE @PersonId int

DECLARE @FirstName varchar(50)

DECLARE @LastName varchar(50)

SET @PersonId = 1

--Return a single record

SELECT
@FirstName = ISNULL(FirstName,''),

@LastName = ISNULL(LastName,''),

FROM People

WHERE             PersonId = @PersonId

END Also, can someone refer me to a good source of PL-SQL documentation similar to MS SQL' Books Online (PL-SQL-specific stuff to learn the syntax) Received on Wed Jun 07 2006 - 10:27:43 CDT