Assign a Table Row to RECORD Variable in Oracle

Q

How To Assign a Table Row to a RECORD Variable in Oracle?

✍: FYIcenter.com

A

If you have a table, and want to assign a data row of that table to a RECORD variable, you need to define this RECORD variable to match the table column structure, then use the SELECT ... INTO statement to assign a data row that RECORD variable. The script below shows you how to do this:

CREATE OR REPLACE PROCEDURE FYI_CENTER AS
  manager employees%ROWTYPE;
BEGIN
  SELECT * INTO manager FROM employees 
    WHERE employee_id = 100;
  DBMS_OUTPUT.PUT_LINE('My manager = ' || 
    manager.first_name || ' ' || manager.last_name);
END;
/
My manager = Steven King

 

Working with Database Objects in Oracle PL/SQL

⇒⇒Oracle Database Tutorials

2016-10-17, 144👍, 0💬