Data Modifications in SQL/Oracle

SQL INSERT INTO Statement

This statement is used to insert new row into a table.

SQL INSERT INTO Syntax

· INSERT INTO table_name
VALUES (value1, value2, value3,...)

· INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

Insert into employee_dtl values(10002,’Ganesh’,3,’04/05/2009’,2);

Emp_Id	Emp_Name	Department_id	Join_dt	Designation
10001	Manu	1	06/06/2008	1
10254	Meera	1	09/04/2006	3
13654	Thilak	2	09/05/2009	4
10002	Ganesh	3	04/05/2009	2

Insert into employee_dtl(emp_code,emp_name,department_id,designation_id)

Values(13555,’abi’,4,3)

Emp_Id	Emp_Name	Department_id	Join_dt	Designation
10001	Manu	1	06/06/2008	1
10254	Meera	1	09/04/2006	3
13654	Thilak	2	09/05/2009	4
10002	Ganesh	3	04/05/2009	2
13555	abi	4		3