---
title: API for Oracle Database- Universal API
date: 2025-12-11T08:07:16Z
modified: 2026-06-15T05:52:46Z
permalink: "https://ezintegrations.ai/docs/use-api-for-oracle-database/"
type: docs
status: publish
excerpt: ""
wpid: 3935
doc_category:
  - Universal API for Database
author: Automation Hub
---

The Universal API for Oracle Database provides a unified interface to interact with Oracle Database instances. Using this API, you can securely authenticate and execute SQL queries, including SELECT, INSERT, UPDATE, and DELETE operations, without worrying about database-specific connection details.

This API leverages OAuth 2.0 for secure authentication, allowing developers to focus on data analytics, reporting, and application logic while maintaining full control over Oracle Database operations. Whether you are retrieving data or performing schema updates, the Universal API simplifies and standardizes database interactions.

Below are the endpoints and usage details to get started with Oracle Database operations using the Universal API:

---

## POST Token

**Endpoint:**
`{{base_url}}/token`

This endpoint is used to retrieve an authentication token from the API. The token serves as an authorization mechanism to access and interact with the various API endpoints.

### Body (form-data)

- **username:** {{Username}}
- **password:** {{Password}}

---

## POST – API for Oracle Database

**Endpoint:**
`{{base_url}}/universalAPI?db_name=Oracle Database&db_version=All`

### Authorization

OAuth 2.0

### Query Parameters

- **db\_name:** Oracle Database
- **db\_version:** All

### Body (raw JSON)

{
  "username": "{{username}}",
  "password": "{{password}}",
  "query": "{{SELECT/INSERT QUERY}}",
  "schema_name": "{{schema_name}}",
  "hostname": "{{host_name}}",
  "portnumber": {{port_number}}
}

## Topics

**Docs Categories:** [Universal API for Database](https://ezintegrations.ai/wp-content/uploads/wp-mfa-exports/taxonomy/doc_category/universal-api-for-database.md)