Collections:
Insert Multiple Rows with 1 INSERT Statement in Oracle
How To Insert Multiple Rows with One INSERT Statement in Oracle?
✍: FYIcenter.com
If you want to insert multiple rows with a single INSERT statement, you can use a subquery instead of the VALUES clause. Rows returned from the subquery will be inserted the target table.
The following tutorial exercise gives a good example:
INSERT INTO fyi_links SELECT department_id, department_name||'.com', NULL, NULL, SYSDATE FROM departments WHERE department_id >= 250; 3 row created. SELECT * FROM fyi_links; ID URL NOTES COUNTS CREATED ----- ------------------------ -------- ------- --------- 101 http://dev.fyicenter.com NULL 0 30-Apr-06 102 http://dba.fyicenter.com NULL 0 07-MAY-06 103 http://sqa.fyicenter.com NULL NULL 07-MAY-06 250 Retail Sales.com NULL NULL 07-MAY-06 260 Recruiting.com NULL NULL 07-MAY-06 270 Payroll.com NULL NULL 07-MAY-06
⇒ Update Values in a Table in Oracle
⇐ Omit Columns in INSERT Statements in Oracle
2020-01-29, 1929🔥, 0💬
Popular Posts:
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...