Oracle Database 19c

Oracle Database 19c is a multi-model database management system that provides a comprehensive platform for enterprise data management, analytics, and application development.

6 APIs 0 Features

DatabaseEnterpriseJsonMachine-LearningNosqlOracleRestSql

APIs

Oracle REST Data Services (ORDS)

RESTful web services for Oracle Database enabling HTTP access to database resources, SQL queries, and PL/SQL procedures.

Oracle Database SODA (Simple Oracle Document Access)

Document-oriented NoSQL-style API for storing, retrieving, and querying JSON documents in Oracle Database.

Oracle SQL Developer Web

Browser-based interface for Oracle Database providing SQL worksheet, data modeler, and database administration capabilities.

Oracle Database API for MongoDB

MongoDB-compatible API allowing MongoDB applications to connect to Oracle Database.

Oracle Database JSON Collections API

RESTful API for managing JSON document collections with CRUD operations.

Oracle Database REST API for AutoML

REST APIs for Oracle Machine Learning AutoML capabilities including model building and deployment.

Collections

Oracle Database 19c - Oracle REST Data Services (ORDS) API

OPEN

Pricing Plans

Oracle Database 19C Plans Pricing

5 plans

PLANS

Rate Limits

Oracle Database 19C Rate Limits

4 limits

RATE LIMITS

FinOps

Oracle Database 19C Finops

FINOPS

Semantic Vocabularies

Oracle Database 19C Context

11 classes · 14 properties

JSON-LD

JSON Structure

Oracle Database 19C Structure

0 properties

JSON STRUCTURE

Resources

👥

GitHubOrganization

Sources

opencollection: 1.0.0
info:
  name: Oracle Database 19c - Oracle REST Data Services (ORDS) API
  version: 19.2.0
request:
  auth:
    type: basic
    username: '{{username}}'
    password: '{{password}}'
items:
- info:
    name: SQL
    type: folder
  items:
  - info:
      name: Execute SQL
      type: http
    http:
      method: POST
      url: https://{host}:{port}/ords/:schema/_/sql
      params:
      - name: schema
        value: ''
        type: path
        description: ORDS-enabled schema alias
      body:
        type: json
        data: '{}'
    docs: Execute SQL
- info:
    name: Metadata
    type: folder
  items:
  - info:
      name: List the schema's REST endpoints catalog
      type: http
    http:
      method: GET
      url: https://{host}:{port}/ords/:schema/metadata-catalog/
      params:
      - name: schema
        value: ''
        type: path
        description: ORDS-enabled schema alias
    docs: List the schema's REST endpoints catalog
- info:
    name: AutoREST
    type: folder
  items:
  - info:
      name: Query an AutoREST-enabled table or view
      type: http
    http:
      method: GET
      url: https://{host}:{port}/ords/:schema/:table/
      params:
      - name: schema
        value: ''
        type: path
        description: ORDS-enabled schema alias
      - name: table
        value: ''
        type: path
      - name: q
        value: ''
        type: query
      - name: limit
        value: ''
        type: query
      - name: offset
        value: ''
        type: query
    docs: Query an AutoREST-enabled table or view
  - info:
      name: Insert a row
      type: http
    http:
      method: POST
      url: https://{host}:{port}/ords/:schema/:table/
      params:
      - name: schema
        value: ''
        type: path
        description: ORDS-enabled schema alias
      - name: table
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Insert a row
  - info:
      name: Get a row by primary key
      type: http
    http:
      method: GET
      url: https://{host}:{port}/ords/:schema/:table/:id
      params:
      - name: schema
        value: ''
        type: path
        description: ORDS-enabled schema alias
      - name: table
        value: ''
        type: path
      - name: id
        value: ''
        type: path
    docs: Get a row by primary key
  - info:
      name: Update a row by primary key
      type: http
    http:
      method: PUT
      url: https://{host}:{port}/ords/:schema/:table/:id
      params:
      - name: schema
        value: ''
        type: path
        description: ORDS-enabled schema alias
      - name: table
        value: ''
        type: path
      - name: id
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Update a row by primary key
  - info:
      name: Delete a row
      type: http
    http:
      method: DELETE
      url: https://{host}:{port}/ords/:schema/:table/:id
      params:
      - name: schema
        value: ''
        type: path
        description: ORDS-enabled schema alias
      - name: table
        value: ''
        type: path
      - name: id
        value: ''
        type: path
    docs: Delete a row
- info:
    name: SODA
    type: folder
  items:
  - info:
      name: List documents in a SODA collection
      type: http
    http:
      method: GET
      url: https://{host}:{port}/ords/:schema/soda/latest/:collection
      params:
      - name: schema
        value: ''
        type: path
        description: ORDS-enabled schema alias
      - name: collection
        value: ''
        type: path
      - name: limit
        value: ''
        type: query
      - name: offset
        value: ''
        type: query
    docs: List documents in a SODA collection
  - info:
      name: Insert a document into a SODA collection
      type: http
    http:
      method: POST
      url: https://{host}:{port}/ords/:schema/soda/latest/:collection
      params:
      - name: schema
        value: ''
        type: path
        description: ORDS-enabled schema alias
      - name: collection
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Insert a document into a SODA collection
  - info:
      name: Get a SODA document by key
      type: http
    http:
      method: GET
      url: https://{host}:{port}/ords/:schema/soda/latest/:collection/:key
      params:
      - name: schema
        value: ''
        type: path
        description: ORDS-enabled schema alias
      - name: collection
        value: ''
        type: path
      - name: key
        value: ''
        type: path
    docs: Get a SODA document by key
  - info:
      name: Replace a SODA document
      type: http
    http:
      method: PUT
      url: https://{host}:{port}/ords/:schema/soda/latest/:collection/:key
      params:
      - name: schema
        value: ''
        type: path
        description: ORDS-enabled schema alias
      - name: collection
        value: ''
        type: path
      - name: key
        value: ''
        type: path
      body:
        type: json
        data: '{}'
    docs: Replace a SODA document
  - info:
      name: Delete a SODA document
      type: http
    http:
      method: DELETE
      url: https://{host}:{port}/ords/:schema/soda/latest/:collection/:key
      params:
      - name: schema
        value: ''
        type: path
        description: ORDS-enabled schema alias
      - name: collection
        value: ''
        type: path
      - name: key
        value: ''
        type: path
    docs: Delete a SODA document
bundled: true