invantive documentation
Invantive Support ForumsLog In / Sign Up

PROVIDERSAMPLEQUERIES: 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) 556

Table Columns

The columns of the table PROVIDERSAMPLEQUERIES 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
RUN_ID guid run_id
SQL_STATEMENT varchar2 Sample SQL Statement Sample SQL statement.
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: