Oracle
App Overview
Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing, data warehousing and mixed database workloads.
Getting Started: Installations
| Name | Type | Description | Exemple | Hidden |
|---|---|---|---|---|
| user | string | false | ||
| password | string | true | ||
| connectionMode | string | false | ||
| host | string | false | ||
| port | string | false | ||
| connectionString | string | false | ||
| serviceName | string | false | ||
| sid | string | false |
App Items
Events
ETL_TASK
Technical Actions
Delete Rows
Delete rows from a table
Inputs
| Name | Type | Description | Exemple | Required |
|---|---|---|---|---|
| tableName | string | The name of the table | Enter your table name | true |
| deleteBy | object | The filter criteria to select rows to delete. Each criteria added is an AND condition | true |
Outputs
| Name | Type | Description | Exemple |
|---|---|---|---|
| deletedCount | number | The number of deleted rows |
Update Rows
Update rows in a table
Inputs
| Name | Type | Description | Exemple | Required |
|---|---|---|---|---|
| tableName | string | The name of the table | Enter your table name | true |
| rowsToUpdate | object | The rows to update in the table. (name | John) | true | |
| useFilter | boolean | Enable filter options | false | |
| filterBy | object | The filter criteria to select rows to update. Each criteria added is an AND condition. (id | 123) | false |
Outputs
Version(s)
1.0.3 