Inserting Into a Table

Syntax

INSERT INTO <table_name> [(<column_name> [, <column_name>] ...) ]
            { VALUES (<expression> [,<expression] ...) | <query>}

Example

SQL> INSERT INTO EMP VALUES
        (7369,'SMITH','CLERK',7902,'17-DEC-80',800,NULL,20);
  2  
1 row created.

SQL> INSERT INTO EMP VALUES
        (7499,'ALLEN','SALESMAN',7698,'20-FEB-81',1600,300,30);
  2  
1 row created.

SQL> INSERT INTO EMP VALUES
        (7521,'WARD','SALESMAN',7698,'22-FEB-81',1250,500,30)
  2    3  ;

1 row created.