Adding Data using INSERT statement

The Oracle Database enables you to store data in tables by inserting rows into them. The records being inserted must match the structure of the table. Each record should have values that match the different columns in the table.

You have to use the INSERT statement to add rows to a table

INSERT Statement

Syntax

INSERT INTO [table] (column1, column2, ...)

 		VALUES (value1, value2, ...)

Example

INSERT INTO DEPARTMENTS 
	(DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
	VALUES 
	(50, ’PRODUCTION’, 103, 1400);