Save record in a variable

[tfg]

How do I recover an entire record and save in a variable?

[dr_gori]

This code is a very good practice.

Select all

DECLARE 
 
  --declara o cursor desejado 
  CURSOR cur_emp ( p_empno EMP.EMPNO%TYPE )  
  IS 
  SELECT * FROM EMP WHERE EMPNO=p_empno; 
 
  --declara o array que conterá a linha toda 
  rec_emp cur_emp%ROWTYPE; 
 
BEGIN 
  --Pega a linha desejada e grava no array 
  OPEN cur_emp ( 7788 ); 
  FETCH cur_emp INTO rec_emp; 
  CLOSE cur_emp; 
 
  DBMS_OUTPUT.PUT_LINE( rec_emp.ENAME ); 
END; 

Select all

SQL> set serveroutput on 
SQL> @t 
SCOTT 
 
PL/SQL procedure successfully completed. 
 
SQL>