Collections:
Insert a RECORD into a Table in Oracle
How To Insert a RECORD into a Table in Oracle?
✍: FYIcenter.com
If you have a RECORD variable with data fields matching a table structure, you can insert a row to this table with this RECORD variable using the INSERT statement as shown in the example 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; DBMS_OUTPUT.PUT_LINE('# rows inserted = ' || SQL%ROWCOUNT); END; / # rows inserted = 1
2018-08-14, 801👍, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Count Duplicated Values in a Column in SQL Server? If you have a column with duplicated value...