INSERT INTO statement is used to insert new rows in a database table.. To do this, include multiple lists of column values within the INSERT INTO statement. In SQL Server you can insert multiple rows using a single SQL INSERT statement . INSERT INTO MyTable (Column1, Column2) VALUES (Value1. So to create a. SQLite provides various forms of the INSERT statements that allow you to insert a single row, multiple rows, and default values into a table. In addition, you can. The syntax for the Oracle INSERT statement when inserting a single record using the VALUES keyword is: INSERT INTO table (column1, column2, column_n).