invantive documentation
Invantive Support ForumsLog In / Sign Up

PROVIDERSYSTEMTABLES: 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) 5,756

Table Columns

The columns of the table PROVIDERSYSTEMTABLES 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_RESULT char Cache Result Whether the result of the execution can be cached for the lifetime of the statement.
CAN_DELETE char Can Delete Indicator whether you can delete data in this table.
CAN_INSERT char Can Insert Indicator whether you can insert data in this table.
CAN_SELECT char Can Select Indicator whether you can select data in this table.
CAN_UPDATE char Can Update Indicator whether you can update data in this table.
CATALOG varchar2 Catalog Catalog where the tables are contained in.
CLIENT_SIDE_CACHEABLE char Client-Side Cacheable Are the contents eligible for caching on the client?
DESCRIPTION varchar2 Description Description of the contents.
DOCUMENTATION varchar2 Documentation Documentation.
EDI_CLASS_NAME varchar2(240) EDI Class Name EDI: master class name.
EDI_PATH_FROM_MASTER varchar2(240) EDI Path from Master EDI: path from the master instance.
ESTIMATED_NUMBER_OF_ROWS int64 Estimated Number of Rows Estimated number of rows in this table per partition.
ESTIMATED_SIZE_BYTES int64 Estimated Size in Bytes Estimated size in bytes of this table per partition.
EXAMPLE varchar2 Example Example of the contents.
FULL_QUALIFIED_NAME varchar2 Full Qualified Name Fully qualified name.
IS_PARTITION_SPECIFIC char Is Partition Specific Indicator whether the contents of this table typically differ per partition.
LABEL_PLURAL varchar2 Label Plural Label of the table contents in plural form.
LABEL_SINGULAR varchar2 Label Singular Label of the table contents in singular form.
NAME varchar2 Name Name of the table or view.
ODATA_BASE_PATH varchar2(240) OData Base Path OData: base path.
ODATA_FIELD_SELECTION_METHOD varchar2(240) OData Field Selection Method OData: field selection method.
ODATA_METADATA_URL varchar2(4000) OData Metadata URL OData: URL for retrieving metadata.
ODATA_SERVER_SIDE_FILTERS varchar2 OData Server-side Filters OData: text representation of server-side filters.
ODATA_SERVICE_URL_FOR_DELETE varchar2(4000) OData Service URL for Delete OData: service URL for deleting data.
ODATA_SERVICE_URL_FOR_INSERT varchar2(4000) OData Service URL for Insert OData: service URL for inserting data.
ODATA_SERVICE_URL_FOR_SELECT varchar2(4000) OData Service URL for Select OData: service URL for retrieving data.
ODATA_SERVICE_URL_FOR_UPDATE varchar2(4000) OData Service URL for Update OData: service URL for updating data.
PRIMARY_KEY_FIELD varchar2(4000) Primary Key Columns Primary key column(s) of the table.
PROVIDER_DATA_CONTAINER_ALIAS varchar2(4000) Data Container Alias Data container alias.
RUN_ID guid run_id
SCHEMA varchar2 Schema Schema within the catalog where the table is contained in.
SHORT_NAME varchar2 Short Name Typical alias for the table.
SOAP_ACTION varchar2(240) SOAP Action SOAP: action.
STATIC_AVERAGE_ACCESS_LATENCY_MS double Static Average Access Latency (ms) Technical average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured.
STATIC_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE int32 Static Average Rows per Minute on Full Scan Average number of rows that fetched per minute on a full table scan, statically configured.
STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE int32 Static Average Rows per Minute on Point Query Average number of rows processed per minute on point queries, statically configured.
STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE int32 Static Average Rows per Minute Written Average number of rows written per minute, statically configured.
SWAGGER_DELETE_OPERATION varchar2(240) Swagger Delete Operation SWAGGER: delete operation.
SWAGGER_INSERT_OPERATION varchar2(240) Swagger Insert Operation SWAGGER: insert operation.
SWAGGER_SELECT_OPERATION varchar2(240) Swagger Select Operation SWAGGER: select operation.
SWAGGER_UPDATE_OPERATION varchar2(240) Swagger Update Operation SWAGGER: update operation.
TABLE_PARAMETERS varchar2(4000) Parameters Parameters defined on the table.
TECHNICAL_DOCUMENTATION varchar2 Technical Documentation Technical documentation.
TYPE varchar2 Type Type, can be either 'view' or 'table'.
WEBHOOK_KEY_FIELD varchar2(4000) Webhook Key Column Key column on webhook messages.
WEBHOOK_TOPIC varchar2(4000) Topic Webhook topic.
XML_BASE_XPATH varchar2(240) Base XPath XML: XPath expression which forms the root containing all rows.
XML_DEFAULT_NAMESPACE_PREFIX varchar2(240) Default Namespace Prefix XML: default namespace prefix.
XML_NAMED_COMPLEX_TYPE varchar2(240) Named Complex Type XML: name of the complex type.
XML_SERVER_SIDE_FILTERS varchar2 Server-side Filters XML: text representation of server-side filters.
XML_SERVICE_URL varchar2(240) Service URL XML: Service URL.
XML_TOPIC varchar2(240) Topic XML: topic or action as known on the remote server. Defaults to Name when not set.
XML_XPATH varchar2(240) XPath XML: XPath expression for the data when specified or the root otherwise. The XPath typically does NOT include the base XPath.
domain_code varchar2 Domain Code domain_code Code of the domain.
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: