Re: SELECT INTO

SELECT INTO is used to retrieve data into variables in the DECLARE section of a PL/SQL program.

DECLARE
v_name VARCHAR2(10);

BEGIN
SELECT name
  INTO v_name
  FROM name_db
;
END
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri May 05 2000 - 00:00:00 CDT