insert into oracle
INSERT INTO table
(column1, column2, ... column_n )
VALUES
(expression1, expression2, ... expression_n );
3
2
INSERT INTO my_table SELECT * FROM source_table;
INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table;
INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table s
WHERE s.my_col >= 10;
Thank you!
2
0
0
0
INSERT INTO table
(column1, column2, ... column_n )
SELECT expression1, expression2, ... expression_n
FROM source_table
[WHERE conditions];
Thank you!
0
0
4
8
INSERT INTO table_name (a, b) VALUES (val1, val2);
INSERT INTO table_name (a, b) VALUES (val1, val2), (val3, val4); -- 2 rows
-- From a query:
INSERT INTO table_name (a, b)
SELECT val1 AS a, val2 AS b
FROM source_table s
WHERE s.val1 >= 10;
Thank you!
8
0
Are there any code examples left?
New code examples in category SQL