2 Programming Features in PL/SQL in TimesTen
This chapter surveys the main PL/SQL programming features providing examples.
See Overview of PL/SQL in Oracle Database PL/SQL Language Reference. Unless otherwise noted, the examples have the same results in TimesTen as in Oracle Database.
See the end of the chapter for TimesTen-specific considerations. See TimesTen PL/SQL Components and Operations for an overview of how applications interact with TimesTen in general and PL/SQL in particular.
The following are the main topics of this chapter:
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.