Oracle® TimesTen In-Memory Database PL/SQL Packages Reference Release 11.2.1 Part Number E14000-03 |
|
|
View PDF |
The TT_DB_VERSION
package indicates the TimesTen version numbers.
This chapter contains the following topics:
Overview
Constants
Examples
The TT_DB_VERSION
package indicates the TimesTen major release (VERSION
) and minor release (RELEASE
) version numbers. For any TimesTen 11.2.1.x release, the VERSION
value is 1121. Depending on the minor release, the RELEASE
value would be 0, 1, 2, and so on.
The package for Oracle TimesTen In-Memory Database Release 11.2.1.8.0 is as follows:
PACKAGE TT_DB_VERSION IS VERSION CONSTANT PLS_INTEGER := 1121; -- major release number RELEASE CONSTANT PLS_INTEGER := 8; -- minor release number END TT_DB_VERSION;
The TT_DB_VERSION
package contains different constant values for different TimesTen releases. The Oracle TimesTen In-Memory Database Release 11.2.1.8.0 version of the TT_DB_VERSION
package has the values shown in Table 8-1.
Table 8-1 TT_DB_VERSION constants
Name | Type | Value | Description |
---|---|---|---|
|
|
1121 |
Current major release of the Oracle TimesTen In-Memory Database. |
|
|
8 |
Current minor release of the Oracle TimesTen In-Memory Database. |
Notes:
The PLS_INTEGER
and BINARY_INTEGER
data types are identical. This document uses BINARY_INTEGER
to indicate data types in reference information (such as for table types, record types, subprogram parameters, or subprogram return values), but may use either in discussion and examples.
The INTEGER
and NUMBER(38)
data types are also identical. This document uses INTEGER
throughout.
See "Examples" in the UTL_IDENT
chapter for an example that uses both that package and TT_DB_VERSION
for conditional compilation.