The following INSERT statement is used to populate a table with rows:

INSERT INTO emp VALUES (7369,'SMITH','CLERK',7902,'17-DEC-80',800,NULL,20);
Note All data types use obvious input formats. Constants that are not simple numeric values must be enclosed by single quotation marks ('). The DATE type supports a wide range of content. In this tutorial, the unambiguous format in this example is recommended.

The syntax requires you to remember the order of the columns. An alternative syntax allows you to list the columns:

INSERT INTO emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)
    VALUES (7499,'ALLEN','SALESMAN',7698,'20-FEB-81',1600,300,30);

You can list the columns in a different order or omit some columns in some cases, for example, if the commission is unknown. The following example shows this type of query:

INSERT INTO emp(empno,ename,job,mgr,hiredate,sal,deptno)
    VALUES (7369,'SMITH','CLERK',7902,'17-DEC-80',800,20);

Many developers prefer an explicit list of columns to relying on implicit sorting.