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, 1933🔥, 0💬
Popular Posts:
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...