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, 1501🔥, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...