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_ |
varchar2 |
Database Data Type | Data type in the database. | ||
DATA_ |
varchar2 |
Data Format | Data format. | ||
DEFAULT_ |
varchar2 |
Default Value | Default value. | ||
DOCUMENTATION |
varchar2 |
Documentation | Documentation. | ||
DOTNET_ |
varchar2 |
.NET Data Type | Data type for .NET. | ||
NAME |
varchar2 |
Name | Name of the column. | ||
PRESENCE_ |
char |
Presence Required | Whether the presence of a value is required. | ||
RUN_ID |
guid |
run_id |
|||
SORTING_ |
int32 |
Sort Order | Sorting order of the parameter within the table function. | ||
TABLE_ |
varchar2 |
Table Catalog | Catalog where the tables are contained in. | ||
TABLE_ |
varchar2 |
Table Full Qualified Name | Full qualified name. | ||
TABLE_ |
varchar2 |
Table Name | Name of the table or view. | ||
TABLE_ |
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: