invantive documentation
Invantive Support ForumsLog In / Sign Up

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_KEY varchar2(240) Cache Key Unique cache key.
EXPRESSION varchar2 Expression Debug view.
FIRST_SOURCE_CODE varchar2 First Source Code First source code.
ID int64 ID Unique ID of the precompiled expression.
INITIAL_REGISTRATION datetime Initial Registration Initial registration.
LAST_USAGE datetime Last Usage Last time used.
USAGE_COUNTER 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: