Actions3
Update
AI-generatedSummary
Update data in an Oracle 11g table
Inputs
- table — Name of the table
- setClause — SET clause for UPDATE (use :paramName for parameters)
- whereClause — WHERE clause for UPDATE (use :paramName for parameters)
- parameters — Parameters for the SQL query
Output shape
an object containing operation, rowsAffected and success
Only returned for successful updates; errors are handled separately.
Examples
Example 1: Update employee salary
table=employees, setClause=salary = :salary, whereClause=id = :id, parameters=[{name=salary,value=50000},{name=id,value=123}]
Example 2: Mark order as completed
table=orders, setClause=status = :status, whereClause=order_id = :oid, parameters=[{name=status,value=Completed},{name=oid,value=456}]