> For the complete documentation index, see [llms.txt](https://doc.duaer.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.duaer.com/integrations/builtin/app-nodes/duaer-nodes-base.oracledatabase.md).

# Use Oracle Database in Duaer

In Duaer, the Oracle Database node works with Oracle Database from a digital organization. It offers 6 operations: Delete, Execute SQL, Insert, Insert or Update, Select, and Update.
## Add Oracle Database to a Duaer digital organization

1. On the Duaer canvas, open the node panel, search for Oracle Database, and connect it after the previous node.
2. In Credential to connect with, pick or create an Oracle Database Credentials API credential.
3. Pick an Operation, for example Insert or Update.
4. Select Execute step and check the output.

## Oracle Database operations in Duaer

- Delete: Delete an entire table or rows in a table.
- Execute SQL: Execute an SQL.
- Insert: Insert rows in a table.
- Insert or Update: Insert or update rows in a table.
- Select: Select rows from a table.
- Update: Update rows in a table.

## Use Oracle Database as a tool for an AI Agent in Duaer

In the Tool input of an AI Agent, search for Oracle Database and add it. The agent decides when to call it. For a field the model should fill, select the sparkle next to it or write $fromAI('name', 'what to put here'); fixed values stay as you set them.

## Call a Oracle Database endpoint the node does not cover

Add an HTTP Request node, set Authentication to Predefined Credential Type, pick Oracle Database Credentials API as the credential type, and select the same credential. Duaer signs the request with it, so you only fill in the method and URL. Refer to [custom operations](/integrations/custom-operations.md).
## Questions

### What can the Oracle Database node do in Duaer?

In Duaer, Oracle Database offers Delete, Execute SQL, Insert, Insert or Update, Select, and Update.

### Which credential does Oracle Database use in Duaer?

Duaer's Oracle Database uses an Oracle Database Credentials API credential. The secret stays in the credential, not in node parameters.