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, 1261👍, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Query Multiple Tables Jointly in MySQL? If you want to query information stored in multiple t...
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard ...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...