Snippet Name: INSERT: Single Column Table Or View Description: Simple single table/column SELECT examples. 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: Multiple Column Table Or View ... » FORALL Insert » INSERT Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 04th, 2009
Description: Simple single table/column SELECT examples.
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: Multiple Column Table Or View ... » FORALL Insert » INSERT
INSERT INTO <table_name> (<column_name>) VALUES (<value>); CREATE TABLE cars( car_model VARCHAR2(50)); INSERT INTO cars (car_model) VALUES ('Accord'); COMMIT; SELECT * FROM cars;