Ejemplo de código de inserción de múltiples filas de Oracle SQL

Ejemplo 1: agregar una tabla de filas múltiples 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

Ejemplo 2: sql insert all

-----------------------------------------------------------------
-- OPTION 1: Insert specific values (other values will be null)

-- syntax 
INSERT INTO <TABLE_NAME> (<column1>,<column2>,<column3>,...) 
VALUES (<value1>,<value2>,<value3>,...);

-- example
INSERT INTO SALES (SALE_ID,ITEM_ID,QUANTITY,AMOUNT)
VALUES (631,13,4,59.99);
-----------------------------------------------------------------
-- OPTION 2: Insert a value for every field

-- syntax
INSERT INTO <TABLE_NAME> (<value1>,<value2>,...,<valueN>);

-- example (SALES table only consists of 4 columns)
INSERT INTO SALES (631,13,4,59.99);
-----------------------------------------------------------------

---

---

Utiliza Nuestro Buscador