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 vote115 views1 answer
How to use query in nosql
SQL
1 vote115 views1 answer
Alphabetical order mysql
SQL
0 vote127 views1 answer
Space not removing from column in sql
SQL
1 vote117 views1 answer
How to see which columns are indexxed mysql
SQL
0 vote134 views1 answer
Insert into table with only identity column
SQL
0 vote112 views1 answer
Oracle activate program
SQL
1 vote121 views1 answer
Postgres left join
SQL
0 vote121 views1 answer
Tsql cmd exec script from file
SQL
0 vote124 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote101 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL