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);
-----------------------------------------------------------------
¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)