Snippet Name: INSERT: Multiple Column Table Or View (All Columns) Description: Simple insert examples (multiple column inserts). Also see:» INSERT With Returning Clause » Create Table INSERT (CTAS) » Inserting into SELECT statement » INSERT WITH CHECK OPTION » INSERT FIRST WHEN » INSERT ALL WHEN » INSERT ALL » INSERT WHEN » INSERT: Using A Record » INSERT with Select » INSERT: Multiple Column Table Or View ... » INSERT: Single Column Table Or View » FORALL Insert » INSERT Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 04th, 2009
Description: Simple insert examples (multiple column inserts).
Also see:» INSERT With Returning Clause » Create Table INSERT (CTAS) » Inserting into SELECT statement » INSERT WITH CHECK OPTION » INSERT FIRST WHEN » INSERT ALL WHEN » INSERT ALL » INSERT WHEN » INSERT: Using A Record » INSERT with Select » INSERT: Multiple Column Table Or View ... » INSERT: Single Column Table Or View » FORALL Insert » INSERT
INSERT INTO <table_name> VALUES (<comma_separated_value_list>); ALTER TABLE state ADD (car_manuf VARCHAR2(30)); INSERT INTO cars (car_model, car_manuf) VALUES ('Accord', 'Honda'); COMMIT; SELECT * FROM cars;
