Oracle PL/SQL: INSERT: Multiple Column Table Or View (Not all columns) - INSERT example with multiple columns, tables, or views, not using all columns.

Quick Search:

Oracle PL/SQL: INSERT: Multiple Column Table Or View (Not all columns)

Jump to:

Category: >> Oracle PL/SQL >> INSERT: Multiple Column Table Or View (Not all columns)

<< last

next >>

Snippet Name: INSERT: Multiple Column Table Or View (Not all columns)

Description: INSERT example with multiple columns, tables, or views, not using all columns.

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

INSERT INTO <table_name>
(<comma_separated_column_name_list>)
VALUES
(<comma_separated_value_list>);
 
RENAME cars TO vehicles;
 
ALTER TABLE vehicles
ADD (car_color VARCHAR2(30));
 
INSERT INTO vehicles
(car_model, car_color)
VALUES
('Accord', 'Steel Gray');
 
COMMIT;
 
SELECT * FROM vehicles;