OracleGetNumber
This activity retrieves a numeric value from an Oracle database using a specified SQL query.
Core Functions
- Accepts a SQL query as input
- Sends the query to the connected Oracle database
- Executes the query to retrieve a numeric result
- Returns the resulting number
Inputs
- Query: Represents the SQL query used to retrieve the numeric value from the Oracle database
Type: String
Outputs
- Output: Returns the numeric value retrieved from the database
Type: Integer
Short Technical Summary
A database retrieval activity that executes a SQL query on a connected Oracle database and returns the resulting numeric value from the query result.