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 vote176 views2 answers
Null value in column violates not-null constraint
SQL
0 vote181 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote173 views1 answer
R2dbc-postgresqldriver dependency
SQL
2 votes194 views1 answer
Q operator in plsql
SQL
3 votes134 views1 answer
If 0 return null else return query mysql
SQL
3 votes198 views2 answers
How to force truncate a table in mysql
SQL
1 vote198 views1 answer
Store select query result in variable sql server
SQL
5 votes184 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
2 votes194 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote199 views1 answer
Sql query to find percentage of null values in a table
SQL