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

2 votes217 views1 answer
Sql compare strings
SQL
0 vote222 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote180 views1 answer
Oracle calculate statistics on partition
SQL
3 votes185 views2 answers
Oracle apex view logs
SQL
0 vote153 views1 answer
Sql get month and year from date
SQL
1 vote213 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote260 views1 answer
Mysql select random rows large table
SQL
50 votes284 views6 answers
Sql count duplicate rows
SQL
0 vote180 views1 answer
Drop view in mysql
SQL
0 vote169 views1 answer
Php delete database
SQL