The INSERT statement

You can embed the INSERT statement in programs. Its form and use in a program are the same as described in Modify data with the additional feature that you can use host variables in expressions, both in the VALUES and WHERE clauses. Moreover, in a program you have the additional ability to insert rows with a cursor.