Tag: PL/SQL

  • Building and documenting REST APIs with ORDS

    Building and documenting REST APIs with ORDS

    Building and documenting REST APIs with ORDS Introduction In the first part of the article we will provide an overview of how you can use Oracle REST Data Services for providing APIs directly from your PL/SQL code . The second part covers how to document our Web services using Swagger. Lets begin with a couple

    Explore →

  • Minimal Oracle

    Minimal Oracle

    Minimal Oracle The Oracle Database software is large, several gigabytes in Oracle Home for the part that is deployed on the operating system, and additional megabytes in SYSTEM tablespace for the part that is deployed as stored procedures (mainly the dbms_% packages). And this is not a problem with the traditional deployment methods where you

    Explore →

  • ODC Appreciation Day : Reduce CPU usage by running the business logic in the Oracle Database

    ODC Appreciation Day : Reduce CPU usage by running the business logic in the Oracle Database

    ODC Appreciation Day : Reduce CPU usage by running the business logic in the Oracle Database Here is my #ThanksODC post. A long one… There’s a point that should always be a major topic for database developer community discussions: where to run the procedural code. The access to data is in the database, for sure,

    Explore →

  • A neural network scoring engine in PL/SQL for recognizing handwritten digits

    A neural network scoring engine in PL/SQL for recognizing handwritten digits

    A neural network scoring engine in PL/SQL for recognizing handwritten digits Topic: In this post, you will find an example of how to build and deploy a basic artificial neural network scoring engine using PL/SQL. This post is intended for learning purposes, in particular for Oracle practitioners who want a hands-on introduction to neural networks.

    Explore →