Oracle/PLSQL: Insert multiple rows with a single INSERT statement

Oracle/PLSQL: Insert multiple rows with a single INSERT statement Question: How can I insert multiple rows of explicit data in one SQL command in Oracle? Answer: You can insert multiple rows using the following syntax: INSERT ALL INTO mytable (column1 ...

www.techonthenet.com