INSERT examples

The following statement adds a row to a table, assigning values to two columns:

INSERT INTO EMPLOYEE_PROJECT (EMP_NO, PROJ_ID) VALUES (52, "DGPII")

The next statement specifies values to insert into a table with a SELECT statement:

INSERT INTO PROJECTS;

SELECT * FROM NEW_PROJECTS; 

WHERE NEW_PROJECTS.START_DATE > '06/06/94'