Collections:
Assign a Table Row to RECORD Variable in Oracle
How To Assign a Table Row to a RECORD Variable in Oracle?
✍: FYIcenter.com
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
⇒ Insert a RECORD into a Table in Oracle
⇐ Define a RECORD Variable for a Table Row in Oracle
2018-08-14, 1450🔥, 0💬
Popular Posts:
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...