Oracle 9i Tutorial

Oracle 9i Tutorial : INSERT Statement Syntax

INSERT Statement Syntax

INSERT statement is used to add new rows to table.


Syntax of INSERT statement below :

INSERT Statement Syntax









Only one row can be inserted at a time with this syntax.

INSERT statement can also be used for copying rows from another table.

Syntax below :

INSERT INTO table1 ( column11 , column12 , ….. )
SELECT column21 , column22 , …….
FROM
table2

 Example below :

Leave a Reply