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

-1 vote114 views1 answer
Sql set max value in column
SQL
8 votes116 views1 answer
Show mysql user table
SQL
17 votes122 views4 answers
Mysql remove ubuntu
SQL
1 vote116 views1 answer
Decalre temp table sql
SQL
1 vote108 views1 answer
Database Queries
SQL
15 votes116 views4 answers
Pl sql
SQL
20 votes119 views5 answers
Reset auto increment mysql
SQL
7 votes126 views2 answers
Postgres concat
SQL
0 vote102 views1 answer
SQL SELECT-Klausel
SQL
2 votes102 views2 answers
Postgresql date at timezone
SQL