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
⇒ Update a Table Row with a RECORD in Oracle
⇐ Assign a Table Row to RECORD Variable in Oracle
2018-08-14, 1493🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...