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 vote355 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote313 views1 answer
Sql max min
SQL
0 vote333 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
1 vote571 views1 answer
Postgres convert text to number
SQL
11 votes334 views1 answer
Sql insert multiple rows from select
SQL
1 vote403 views1 answer
STOP message of how many rows affected sql
SQL
0 vote314 views1 answer
Database springboot
SQL
0 vote320 views1 answer
Mariadb maximum left join
SQL
0 vote319 views1 answer
Psql check if value in array
SQL
10 votes392 views6 answers
Mysql set root password
SQL