5 Examples Using TimesTen SQL in PL/SQL

There are additional examples to further explore the tight integration of TimesTen SQL in PL/SQL.

• Examples Using the SELECT...INTO Statement in PL/SQL

• Example Using the INSERT Statement

• Examples Using Input and Output Parameters and Bind Variables

• Examples Using Cursors

• Examples Using FORALL and BULK COLLECT

• Examples Using EXECUTE IMMEDIATE

• Examples Using RETURNING INTO

• Example Querying a System View

Note:

Except where stated otherwise, the examples in this guide use the TimesTen ttIsql utility (which has the Command> prompt). In order to display output in the examples, the setting SET SERVEROUTPUT ON is used. See ttIsql in Oracle TimesTen In-Memory Database Reference.