Insert: Multiple Column Table Or View (All Columns)

Description: Simple insert examples (multiple column inserts).

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;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.