how to insert multiple rows in oracle sql developer using script code example
Example: 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