Best way to do multi-row insert in Oracle?

by

In Oracle, to insert multiple rows into table t with columns col1, col2 and col3 you can use the following syntax:

INSERT ALL
   INTO t (col1, col2, col3) VALUES ('val1_1', 'val1_2', 'val1_3')
   INTO t (col1, col2, col3) VALUES ('val2_1', 'val2_2', 'val2_3')
   INTO t (col1, col2, col3) VALUES ('val3_1', 'val3_2', 'val3_3')
   .
   .
   .
SELECT 1 FROM DUAL;

More Related Contents:

  1. ORA-12560: TNS:protocol adaptor error
  2. SQL Error: ORA-01861: literal does not match format string 01861
  3. ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)
  4. “column not allowed here” error in INSERT statement
  5. Current date in Oracle Db
  6. Split comma separated values to columns in Oracle
  7. How to load a large number of strings to match with oracle database?
  8. SQL IN Clause 1000 item limit
  9. Oracle SELECT TOP 10 records [duplicate]
  10. Avoid duplicates in INSERT INTO SELECT query in SQL Server
  11. Escaping ampersand character in SQL string
  12. ORA-00918: column ambiguously defined in SELECT *
  13. Multiplication aggregate operator in SQL
  14. Pivoting rows into columns dynamically in Oracle
  15. MySQL equivalent of DECODE function in Oracle
  16. How to get Oracle create table statement in SQL*Plus
  17. How do I select all the columns from a table, plus additional columns like ROWNUM?
  18. Disable all table constraints in Oracle
  19. ORA – 00933 confusion with inner join and “as”
  20. OVER clause in Oracle
  21. PARTITION BY with and without KEEP in Oracle
  22. Comparing with date in Oracle sql
  23. Is it possible to query a comma separated column for a specific value?
  24. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  25. SQL selecting rows by most recent date with two unique columns
  26. How to extract group from regular expression in Oracle?
  27. Using LIKE in an Oracle IN clause
  28. How to handle optional parameters in SQL query?
  29. How can I solve ORA-00911: invalid character error?
  30. Exporting a CLOB to a text file using Oracle SQL Developer

Leave a Comment