oracle into

DECLARE
TYPE T_STUDENTRECORD IS RECORD(
STUDENTID VARCHAR2(200),
FIRSTNAME VARCHAR2(200),
LASTNAME VARCHAR2(200));
/*Declare a variable of this type.*/
V_STUDENTINFO T_STUDENTRECORD;
V_SQL VARCHAR2(200);
V_SQL1 VARCHAR2(200);
V_SQL2 VARCHAR2(200);
V_SQL3 VARCHAR2(200);
BEGIN
--SELECT 1, 2, 3 INTO V_STUDENTINFO FROM DUAL;

V_SQL := 'SELECT 1, 2, 3 FROM DUAL';
EXECUTE IMMEDIATE V_SQL
INTO V_SQL1, V_SQL2, V_SQL3;
DBMS_OUTPUT.PUT_LINE(V_SQL1);
DBMS_OUTPUT.PUT_LINE(V_SQL2);
DBMS_OUTPUT.PUT_LINE(V_SQL3);

EXECUTE IMMEDIATE V_SQL
INTO V_STUDENTINFO;
DBMS_OUTPUT.PUT_LINE(V_STUDENTINFO.STUDENTID);
DBMS_OUTPUT.PUT_LINE(V_STUDENTINFO.FIRSTNAME);
DBMS_OUTPUT.PUT_LINE(V_STUDENTINFO.LASTNAME);

END;