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_ |
char |
Cache Result | Whether the result of the execution can be cached for the lifetime of the statement. | ||
CAN_ |
char |
Can Delete | Indicator whether you can delete data in this table. | ||
CAN_ |
char |
Can Insert | Indicator whether you can insert data in this table. | ||
CAN_ |
char |
Can Select | Indicator whether you can select data in this table. | ||
CAN_ |
char |
Can Update | Indicator whether you can update data in this table. | ||
CATALOG |
varchar2 |
Catalog | Catalog where the tables are contained in. | ||
CLIENT_ |
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_ |
varchar2 |
EDI Class Name | EDI: master class name. | ||
EDI_ |
varchar2 |
EDI Path from Master | EDI: path from the master instance. | ||
ESTIMATED_ |
int64 |
Estimated Number of Rows | Estimated number of rows in this table per partition. | ||
ESTIMATED_ |
int64 |
Estimated Size in Bytes | Estimated size in bytes of this table per partition. | ||
EXAMPLE |
varchar2 |
Example | Example of the contents. | ||
FULL_ |
varchar2 |
Full Qualified Name | Fully qualified name. | ||
IS_ |
char |
Is Partition Specific | Indicator whether the contents of this table typically differ per partition. | ||
LABEL_ |
varchar2 |
Label Plural | Label of the table contents in plural form. | ||
LABEL_ |
varchar2 |
Label Singular | Label of the table contents in singular form. | ||
NAME |
varchar2 |
Name | Name of the table or view. | ||
ODATA_ |
varchar2 |
OData Base Path | OData: base path. | ||
ODATA_ |
varchar2 |
OData Field Selection Method | OData: field selection method. | ||
ODATA_ |
varchar2 |
OData Metadata URL | OData: URL for retrieving metadata. | ||
ODATA_ |
varchar2 |
OData Server-side Filters | OData: text representation of server-side filters. | ||
ODATA_ |
varchar2 |
OData Service URL for Delete | OData: service URL for deleting data. | ||
ODATA_ |
varchar2 |
OData Service URL for Insert | OData: service URL for inserting data. | ||
ODATA_ |
varchar2 |
OData Service URL for Select | OData: service URL for retrieving data. | ||
ODATA_ |
varchar2 |
OData Service URL for Update | OData: service URL for updating data. | ||
PRIMARY_ |
varchar2 |
Primary Key Columns | Primary key column(s) of the table. | ||
PROVIDER_ |
varchar2 |
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_ |
varchar2 |
Short Name | Typical alias for the table. | ||
SOAP_ |
varchar2 |
SOAP Action | SOAP: action. | ||
STATIC_ |
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_ |
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_ |
int32 |
Static Average Rows per Minute on Point Query | Average number of rows processed per minute on point queries, statically configured. | ||
STATIC_ |
int32 |
Static Average Rows per Minute Written | Average number of rows written per minute, statically configured. | ||
SWAGGER_ |
varchar2 |
Swagger Delete Operation | SWAGGER: delete operation. | ||
SWAGGER_ |
varchar2 |
Swagger Insert Operation | SWAGGER: insert operation. | ||
SWAGGER_ |
varchar2 |
Swagger Select Operation | SWAGGER: select operation. | ||
SWAGGER_ |
varchar2 |
Swagger Update Operation | SWAGGER: update operation. | ||
TABLE_ |
varchar2 |
Parameters | Parameters defined on the table. | ||
TECHNICAL_ |
varchar2 |
Technical Documentation | Technical documentation. | ||
TYPE |
varchar2 |
Type | Type, can be either 'view' or 'table'. | ||
WEBHOOK_ |
varchar2 |
Webhook Key Column | Key column on webhook messages. | ||
WEBHOOK_ |
varchar2 |
Topic | Webhook topic. | ||
XML_ |
varchar2 |
Base XPath | XML: XPath expression which forms the root containing all rows. | ||
XML_ |
varchar2 |
Default Namespace Prefix | XML: default namespace prefix. | ||
XML_ |
varchar2 |
Named Complex Type | XML: name of the complex type. | ||
XML_ |
varchar2 |
Server-side Filters | XML: text representation of server-side filters. | ||
XML_ |
varchar2 |
Service URL | XML: Service URL. | ||
XML_ |
varchar2 |
Topic | XML: topic or action as known on the remote server. Defaults to Name when not set. | ||
XML_ |
varchar2 |
XPath | XML: XPath expression for the data when specified or the root otherwise. The XPath typically does NOT include the base XPath. | ||
domain_ |
varchar2 |
Domain Code | domain_ |
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: