how to multiple input in single insert command in oracle code example
Example 1: add multiple row table pl sql
INSERT INTO real_table_name (person_id, given_name, family_name, title)
WITH temp_table AS (
SELECT 4, 'Ruth', 'Fox', 'Mrs' FROM dual UNION ALL
SELECT 5, 'Isabelle', 'Squirrel', 'Miss' FROM dual UNION ALL
SELECT 6, 'Justin', 'Frog', 'Master' FROM dual UNION ALL
SELECT 7, 'Lisa', 'Owl', 'Dr' FROM dual
)
SELECT * FROM temp_table
Example 2: sql insert all
INSERT INTO <TABLE_NAME> (<column1>,<column2>,<column3>,...)
VALUES (<value1>,<value2>,<value3>,...);
INSERT INTO SALES (SALE_ID,ITEM_ID,QUANTITY,AMOUNT)
VALUES (631,13,4,59.99);
INSERT INTO <TABLE_NAME> (<value1>,<value2>,...,<valueN>);
INSERT INTO SALES (631,13,4,59.99);