Collections:
Update a Table Row with a RECORD in Oracle
How To Update a Table Row with a RECORD in Oracle?
✍: FYIcenter.com
If you have a RECORD variable with data fields matching a table structure, you can update a row in this table with this RECORD variable using the UPDATE ... SET ROW statement as shown in the sample script below:
CREATE TABLE emp_temp AS SELECT * FROM employees; CREATE OR REPLACE PROCEDURE FYI_CENTER AS manager employees%ROWTYPE; BEGIN SELECT * INTO manager FROM employees WHERE employee_id = 100; manager.employee_id := 299; INSERT INTO emp_temp VALUES manager; manager.first_name := 'FYI'; manager.last_name := 'Center'; UPDATE emp_temp SET ROW = manager WHERE employee_id = 299; DBMS_OUTPUT.PUT_LINE('# rows updated = ' || SQL%ROWCOUNT); END; / # rows updated = 1
2018-08-14, 782👍, 0💬
Popular Posts:
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...