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 vote337 views2 answers
Mysql show foreign keys
SQL
0 vote319 views1 answer
Sql file in postgres with pgadmin
SQL
17 votes304 views3 answers
Cast in sql server
SQL
0 vote339 views1 answer
Copy row from db to db mysql
SQL
0 vote328 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote325 views1 answer
Oracle sql copy table without data
SQL
15 votes300 views2 answers
Open postgress in terminal mac
SQL
0 vote295 views1 answer
Ora 00001 error catch plsql
SQL
0 vote304 views1 answer
Postgres reorder columns
SQL
0 vote316 views1 answer
Column ' ' in field list is ambiguous
SQL