How to enter several values ​​​​at once in a table?

Question

Oracle

There are 500 lines of hash sum files. How can they be brought to the oracle database with one select? Or how can they be imported into a table?

Answer 1

one select

Can be done with Oracle INSERT ALL statement

INSERT ALL
    INTO table_name(col1) VALUES(val1)
    INTO table_name(col1) VALUES(val4)
    INTO table_name(col1) VALUES(val7)
SELECT * FROM dual;

Answer 2

The most clumsy way to prepare a data file.
1. Open the file in Notepad++.
2. Ctrl+H (Replace).
3. Set the search mode to "Regular Expressions".
4. Find:
^
5. Replace (substitute your own table name):
insert into table\(name\) values ​​\('
6. Click "Replace All".
7. Find:
\r
8. Replace:
'\);
9. Click "Replace All".
As a result, you get 500 rows of inserts. Perform them in one transaction in any way possible.