SYSTEMSQLPRECOMPILEDEXPRESSIONS: Data Dictionary SQL Pre-compiled Expressions
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: SQL Pre-compiled Expressions
All compiled SQL statements executed by Invantive's UniversalSQL engine.
Can only retrieve data.
Table Columns
The columns of the table SYSTEMSQLPRECOMPILEDEXPRESSIONS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CACHE_ |
varchar2 |
Cache Key | Unique cache key. | ||
EXPRESSION |
varchar2 |
Expression | Debug view. | ||
FIRST_ |
varchar2 |
First Source Code | First source code. | ||
ID |
int64 |
ID | Unique ID of the precompiled expression. | ||
INITIAL_ |
datetime |
Initial Registration | Initial registration. | ||
LAST_ |
datetime |
Last Usage | Last time used. | ||
USAGE_ |
int32 |
Usage Counter | Number of times the pre-compiled expression was used. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: