Oracle multiple insert

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

Oracle multiple insert

INSERT INTO my_table (col1, col2)
SELECT 8000, 0 FROM DUAL
UNION ALL
SELECT 8001, 5 FROM DUAL;

Similar codes

0 vote138 views1 answer
Less than date query sqlachemy
SQL
0 vote128 views1 answer
Mariadb maximum left join
SQL
18 votes143 views6 answers
Laravel form validation
SQL
4 votes183 views2 answers
Sql select except null
SQL
1 vote140 views1 answer
Sql count value greater than
SQL
0 vote138 views1 answer
Linked server delete openquery
SQL
0 vote141 views1 answer
Oracle concat datetime
SQL
0 vote131 views1 answer
Consecutive numbers sql
SQL
0 vote151 views1 answer
Snowflake drop column
SQL
0 vote126 views1 answer
Oracle last user logon
SQL