invantive documentation
Invantive Support ForumsLog In / Sign Up

PROVIDERTABLEFUNCTIONPARAMETERS: In-Memory

insert update delete

  • Catalog: ``
  • Primary Keys: rowid$

Can retrieve data and change data using insert, update and delete.

Performance Characteristics

Characteristic Value
Estimated rows 0
Estimated size (bytes) 1,656

Table Columns

The columns of the table PROVIDERTABLEFUNCTIONPARAMETERS 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
DATABASE_DATA_TYPE varchar2 Database Data Type Data type in the database.
DATA_FORMAT varchar2(60) Data Format Data format.
DEFAULT_VALUE varchar2 Default Value Default value.
DOCUMENTATION varchar2 Documentation Documentation.
DOTNET_DATA_TYPE varchar2 .NET Data Type Data type for .NET.
NAME varchar2 Name Name of the column.
PRESENCE_REQUIRED char Presence Required Whether the presence of a value is required.
RUN_ID guid run_id
SORTING_ORDER int32 Sort Order Sorting order of the parameter within the table function.
TABLE_CATALOG_NAME varchar2 Table Catalog Catalog where the tables are contained in.
TABLE_FULL_QUALIFIED_NAME varchar2(240) Table Full Qualified Name Full qualified name.
TABLE_NAME varchar2 Table Name Name of the table or view.
TABLE_SCHEMA_NAME varchar2 Table Schema Schema within the catalog where the table is contained in.
rowid$ number Row ID computed Artificial primary key of an in-memory table.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: