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 vote277 views2 answers
Delete the last item in a table sql
SQL
0 vote627 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote348 views1 answer
Modifier une valeur sql
SQL
0 vote336 views2 answers
How to install mssql on mac
SQL
0 vote334 views1 answer
Sql reverse order of results
SQL
0 vote370 views1 answer
Snowflake drop column
SQL
2 votes343 views3 answers
Row number mssql
SQL
1 vote308 views2 answers
Oracle replace
SQL
0 vote336 views1 answer
Mysql query to select the highest value
SQL
0 vote347 views1 answer
Running mysql from bash sc
SQL