Insert Statement

INSERT Statement is used to add new rows to a table.


Syntax:

Insert into <table_name> values (value1,value2..);

e.g.

SQL> insert into employees values(901,'John','S','john@gmail.com','949999333','17-JUN-2010','AD_PRES',20000,0,100,90);

To insert values in specific columns:

SQL>insert into employees(employee_id,first_name,last_name,email,hire_date,job_id) values(902,'Steven','J','steven@gmail.com','17-JUN-2010','AD_PRES');



Have a question or comment? Post it below!

Previous Tutorial   Next Tutorial