Deletar
AI-generatedOverview
This node allows executing SQL operations on an Oracle database. It supports running arbitrary queries as well as common data manipulation operations such as inserting, updating, and deleting rows in specified tables.
Typical use cases include:
- Running custom SELECT queries to retrieve data.
- Inserting new records into a table.
- Updating existing records based on conditions.
- Deleting records matching specific criteria.
For example, you could use this node to delete user accounts from a "users" table where the account status is "inactive", or to insert new product entries into an inventory table.
Properties
| Name | Meaning |
|---|---|
| Tabela | The name of the table on which the operation will be performed (insert, update, delete). |
| Condição WHERE | The WHERE clause condition for update or delete operations (without the word "WHERE"). |
| Opções Adicionais | Additional options: • Tamanho Máximo De Linhas: Maximum number of rows to return. • Converter Datas ISO: Whether to convert date fields to ISO string format. • Commit Automático: Whether to automatically commit changes after the operation. |
Output
The output JSON contains either:
rows: An array of objects representing the rows returned by the query or affected by the operation. If the option to convert dates to ISO is enabled, date fields are converted to ISO strings.rowCount: The count of rows returned (when applicable).rowsAffected: The number of rows affected by insert, update, or delete operations.
No binary data output is produced by this node.
Dependencies
- Requires an Oracle database connection with appropriate credentials.
- Needs an API key credential configured in n8n for authenticating to the Oracle database.
- Uses the official OracleDB Node.js driver (
oracledbpackage).
Troubleshooting
Common issues:
- Incorrect table names or column names can cause SQL errors.
- Malformed WHERE clauses may lead to unintended deletions or updates or SQL syntax errors.
- Insufficient database permissions can prevent execution of certain operations.
- Connection failures due to incorrect credentials or network issues.
Error messages:
"A operação \"<operation>\" não é suportada!"— This means the selected operation is not supported; ensure you choose one of the valid operations: executeQuery, insert, update, or delete.- SQL errors indicating syntax problems usually relate to malformed queries or invalid identifiers.
- Connection errors suggest checking credentials and network connectivity.
To resolve errors, verify all input parameters carefully, especially table names, columns, and WHERE clauses. Ensure the database user has the necessary privileges.