Oracle Insert

Oracle Insert statement

How to use the INSERT statement to add rows into table.

Oracle Insert syntax

INSERT INTO table_name (column names)
VALUES (column values);

Insert example

INSERT INTO CUSTOMERS(ID, NAME, ADDRESS) 
VALUES (1,'Customer_A','Address 1A');

INSERT INTO CUSTOMERS(ID, NAME, ADDRESS) 
VALUES (2,'Customer_B','Address 2B');

INSERT INTO CUSTOMERS(ID, NAME, ADDRESS) 
VALUES (3,'Customer_C','Address 3C');