How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Need help?

Contact us
Oracle

Oracle Nosql API

The nosql API from Oracle — 16 operation(s) for nosql.

Documentation Provider Profile APIs.io OpenAPI GitHub

Oracle Nosql API is one of 378 APIs that Oracle publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include NoSQL. The published artifact set on APIs.io includes an OpenAPI specification and an API reference.

This API exposes 24 operations across 16 paths, and defines 37 schemas. It is described by OpenAPI 3.2.0, at version 20190828.

Requests are made against a single base URL, https://127.0.0.1/20190828.

24 operations 16 paths 37 schemas 5 DELETE12 GET5 POST2 PUT

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
20190828
Base URL
https://{host}:{port}/ords/
Resource Areas
1

Paths & Operations 24

Across 16 paths, the API surfaces 24 operations — 5 DELETE, 12 GET, 5 POST, 2 PUT. Each is listed below with its method, path, parameters, and response codes.

nosql 24
POST
/query
Execute a SQL query.
Query 3 params body → 200400401404429500default
GET
/query/prepare
Prepare a SQL statement for use in a query with variable substitution.
PrepareStatement 4 params → 200400401404429500default
GET
/query/summarize
Check the syntax and return a brief summary of a SQL statement.
SummarizeStatement 3 params → 200400401404429500default
GET
/tables
Get a list of tables in a compartment.
ListTables 8 params → 200400401404429500default
POST
/tables
Create a new table.
CreateTable 2 params body → 202400401404409429500default
DELETE
/tables/{tableNameOrId}
Delete a table by tableNameOrId.
DeleteTable 5 params → 202400401404412429500default
GET
/tables/{tableNameOrId}
Get table info by identifier.
GetTable 3 params → 200400401404429500default
PUT
/tables/{tableNameOrId}
Alter the table identified by tableNameOrId.
UpdateTable 3 params body → 202400401404412429500default
POST
/tables/{tableNameOrId}/actions/changeCompartment
Change a table's compartment.
ChangeTableCompartment 4 params body → 202400401404409412429500
GET
/tables/{tableNameOrId}/indexes
Get a list of indexes on a table.
ListIndexes 9 params → 200400401404429500default
POST
/tables/{tableNameOrId}/indexes
Create a new index.
CreateIndex 3 params body → 202400401404409429500default
DELETE
/tables/{tableNameOrId}/indexes/{indexName}
Delete an index.
DeleteIndex 6 params → 202400401404412429500default
GET
/tables/{tableNameOrId}/indexes/{indexName}
Get information about a single index.
GetIndex 4 params → 200400401404429500default
POST
/tables/{tableNameOrId}/replicas
Add a replica for this table. The table's schema must be frozen prior to this operation.
CreateReplica 4 params body → 202400401404409412429500
DELETE
/tables/{tableNameOrId}/replicas/{region}
Delete a replica.
DeleteReplica 5 params → 202400401404412429500default
DELETE
/tables/{tableNameOrId}/rows
Delete a single row from the table, by primary key.
DeleteRow 7 params → 200400401404412429500default
GET
/tables/{tableNameOrId}/rows
Get a single row from the table by primary key.
GetRow 6 params → 200400401404429500default
PUT
/tables/{tableNameOrId}/rows
Write a single row into the table.
UpdateRow 3 params body → 200400401404412429500default
GET
/tables/{tableNameOrId}/usage
Get table usage info.
ListTableUsage 7 params → 200400401404429500default
GET
/workRequests
List the work requests in a compartment.
ListWorkRequests 4 params → 200400401404429500default
DELETE
/workRequests/{workRequestId}
Cancel a work request operation with the given ID.
DeleteWorkRequest 3 params → 202400401404412429500default
GET
/workRequests/{workRequestId}
Get the status of the work request with the given ID.
GetWorkRequest 2 params → 200400401404429500default
GET
/workRequests/{workRequestId}/errors
List work request errors
ListWorkRequestErrors 4 params → 200400401404429500default
GET
/workRequests/{workRequestId}/logs
Lists work request logs
ListWorkRequestLogs 4 params → 200400401404429500default

Schemas 37

The contract defines 37 schemas that model the data the API accepts and returns. The most detailed are Table (19 properties), TableSummary (15 properties), WorkRequestSummary (9 properties), UpdateRowDetails (9 properties). Each schema is shown below with its type and property counts.

TableLimits
object
Throughput and storage limits configuration of a table.
4 properties 3 required
TableUsageSummary
object
TableUsageSummary represents a single usage record, or slice, that includes information about read and write throughput consumed during that period as well as…
9 properties
QueryDetails
object
All the information surrounding a query, including the query statement, limits, consistency, and so forth.
7 properties 2 required
CreateReplicaDetails
object
Specifications for the new replica
4 properties 1 required
UpdateTableDetails
object
The information to be updated.
5 properties
QueryResultCollection
object
The result of a query.
2 properties
StatementSummary
object
Information derived from parsing a NoSQL SQL statement.
6 properties
UpdateRowResult
object
The result of an UpdateRow operation.
5 properties
WorkRequestErrorCollection
object
Results of ListWorkRequestErrors
1 property
Index
object
Information about an index.
7 properties
Identity
object
The identity properties of a table, if any.
3 properties
WorkRequestError
object
An error encountered while executing a work request.
3 properties 3 required
TableSummary
object
Summary of the table.
15 properties 2 required
WorkRequestSummary
object
A description of workrequest status.
9 properties 7 required
WorkRequest
object
A description of workrequest status.
9 properties 7 required
WorkRequestLogEntryCollection
object
Results of ListWorkRequestLogs
1 property
CreateTableDetails
object
Specifications for the new table.
7 properties 3 required
IndexKey
object
Specifies a single key in a secondary index.
3 properties 1 required
Row
object
The result of GetRow.
3 properties
DeleteRowResult
object
The result of a DeleteRow operation.
4 properties
Column
object
A column of a table.
6 properties
Replica
object
Information about a MR table replica
6 properties
TableUsageCollection
object
Result of GetTableUsage.
1 property
IndexCollection
object
Results of ListIndexes.
1 property
Schema
object
The table schema information as a JSON object.
5 properties 4 required
Error
object
Error Information.
2 properties 2 required
WorkRequestCollection
object
Results of ListWorkRequests
1 property
WorkRequestLogEntry
object
A log message from the execution of a work request.
2 properties 2 required
UpdateRowDetails
object
Specifications for the putting of a table row.
9 properties 1 required
Table
object
Complete metadata about a table.
19 properties 2 required
ChangeTableCompartmentDetails
object
Specification of both from and to compartments.
2 properties 1 required
IndexSummary
object
Information about an index.
4 properties
TableCollection
object
Results of ListTables.
6 properties
CreateIndexDetails
object
Specifications for the new index.
4 properties 2 required
WorkRequestResource
object
A resource created or operated on by a work request.
4 properties 3 required
RequestUsage
object
The usage metrics for a request.
2 properties
PreparedStatement
object
The result of query preparation.
3 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

oracle-nosql-api-openapi.yml Raw ↑

Other APIs Oracle publishes across the network.

Oracle Database REST APIs
AE Profile APIs.io
Oracle Integration Cloud API
AE Profile APIs.io
Oracle Fusion Cloud Applications API
AE Profile APIs.io
Oracle Fusion Cloud Financials REST API
AE Profile APIs.io
Oracle Fusion Cloud HCM REST API
AE Profile APIs.io
Oracle Fusion Cloud CX Sales and Service REST API
AE Profile APIs.io
Oracle Fusion Cloud SCM REST API
AE Profile APIs.io
Oracle Fusion Cloud Procurement REST API
AE Profile APIs.io
Oracle Content Management API
AE Profile APIs.io
OCI Generative AI API
AE Profile APIs.io
OCI AI Vision API
AE Profile APIs.io
OCI AI Language API
AE Profile APIs.io
#NoSQL
← Back to O APIs
API Details
ID
oracle:oracle-nosql-api
Base URL
https://{host}:{port}/ords/
Docs
https://docs.oracle.com/en/database/oracle/oracle-database/
Provider
Oracle
APIs.io →  GitHub →
Explore more
All APIs Providers APIs.io Network
Work with this as data

Every API here is available over the API and to AI agents over MCP. APIs is not yet its own endpoint on the v1 API. Reach this content through network search and the tag graph, or the MCP server below.

Installs https://mcp.apievangelist.com/mcp in Claude, Cursor, VS Code and the rest — one button, every client.

MCP tools for apis
4 tools reach this content
  • search_api_evangelistSearch every content type across the network at once.
  • find_relatedThe shared-tag relevance graph — what else covers this.
  • get_tagEverything one tag labels, across all content types.
  • guide_topicPRO — a curated bundle for a topic: area, guidance, rules, papers, stories, services.
All tools & prompts
Call it yourself
curl for this page
Search the network for this 
curl "https://api.apievangelist.com/v1/search?q=oracle-nosql-api&limit=10"
Everything under a tag 
curl "https://api.apievangelist.com/v1/tags/oracle-nosql-api"

Discovery needs no key. Full bodies and the synthesis endpoints are Pro.

Get an API key

Free tier, no email required. Sign in with whichever identity you already have.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have. Your account

Where this information came from

This is an independent, third-party profile of Oracle Nosql API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.