Skip to content
No results
  • Portfolio
  • Blog
  • Oracle 26ai
  • Oracle APEX
  • Oracle Forms
  • PL/SQL
  • SQL
  • Topics
  • Tools
  • About
  • Roadmaps
    • Oracle APEX Roadmap
    • Oracle Database Roadmap
    • Software Engineering Roadmap
    • AI Developer Roadmap
  • Products
    • VinAura - PDF Designer for APEX
    • Rounds HMS - Hospital ERP
    • SmartShare for WordPress
  • Books
    • APEX 26.1 Book
    • APEX API Book
    • SQL & PL/SQL Book
    • Forms 14c Book
    • Oracle AI & APEX Book
  • Consulting
  • Dev News
Simulators & Games
Vinish Kapoor.
  • Portfolio
  • Blog
  • Oracle 26ai
  • Oracle APEX
  • Oracle Forms
  • PL/SQL
  • SQL
  • Topics
  • Tools
  • VinAura PDF
    See the designerQueries, bands, tables, live preview
    Oracle APEX · PDF reports

    The visual PDF report designer for Oracle APEX

    Design invoices, statements and labels on a canvas, bind them to SQL, and get the PDF with one PL/SQL call.

    • How it works
    • Features
    • Sample PDFs
    • Tutorial
    Get VinAura PDF Free on GitHub
  • Rounds HMS
    See the hospitalOPD, IPD, billing, lab, pharmacy
    Hospital management · HMIS

    The HMS your whole hospital can work in

    A cloud-based hospital management system for OPD, IPD, billing, lab, pharmacy and HMIS reports, built on Oracle APEX.

    • Modules
    • Technology
    • Security
    • User guide
    Get Rounds HMS Cloud-hosted
  • APEX 26.1 Book
    Inside the bookReal pages from the book
    Oracle APEX 26.1 · Book

    Oracle APEX 26.1: The Complete Guide

    Build a real app with reports, grids, security, workflows, REST and AI. 828 pages, paperback and Kindle.

    • What you learn
    • Six parts, 48 chapters
    • Inside the book
    • FAQ
    Get the book Paperback, Kindle & Apple Books
  • APEX API Book
    Inside the bookReal pages from the book
    Oracle APEX 26.1 · JavaScript & PL/SQL

    Oracle APEX 26.1 API by Example

    Every APEX JavaScript and PL/SQL API, 1,850+ methods, events, procedures and functions, each with a runnable example and real output.

    • Syntax, example, output
    • 32 everyday recipes
    • Three parts, 32 chapters
    • FAQ
    Get the book Paperback, Kindle & Apple Books
  • SQL & PL/SQL Book
    Inside the bookReal pages from the book
    Oracle AI Database 26ai · SQL & PL/SQL

    Oracle Database 26ai SQL and PL/SQL

    Every SQL function, statement and developer package of Oracle AI Database 26ai, with 677 examples and their real output.

    • Syntax, example, output
    • 677 examples
    • Eight parts, 66 chapters
    • FAQ
    Get the book Paperback, Kindle & Apple Books
  • Forms 14c Book
    Inside the bookReal pages from the book
    Oracle Forms 14.1.2 · Book

    Oracle Forms 14c: The Complete Developer's Guide

    Build and deploy Forms 14.1.2 apps, with 64 forms run in a real lab and every property, built-in and trigger shown.

    • Syntax, example, screen
    • What's new in 14c
    • Six parts, 40 chapters
    • FAQ
    Get the book Paperback, Kindle & Apple Books
  • Oracle AI Book
    Inside the bookReal pages from the book
    Oracle AI Database 26ai · APEX 26.1

    AI Applications with Oracle Database 26ai and APEX 26.1

    Build vector search, RAG and AI agents in SQL, PL/SQL and Oracle APEX, with 237 examples and their real output.

    • Syntax, example, output
    • 237 examples
    • Five parts, 29 chapters
    • FAQ
    Get the book Paperback, Kindle & Apple Books
Vinish Kapoor.
Simulators & Games
  • VinAura PDF
    See the designerQueries, bands, tables, live preview
    Oracle APEX · PDF reports

    The visual PDF report designer for Oracle APEX

    Design invoices, statements and labels on a canvas, bind them to SQL, and get the PDF with one PL/SQL call.

    • How it works
    • Features
    • Sample PDFs
    • Tutorial
    Get VinAura PDF Free on GitHub
  • Rounds HMS
    See the hospitalOPD, IPD, billing, lab, pharmacy
    Hospital management · HMIS

    The HMS your whole hospital can work in

    A cloud-based hospital management system for OPD, IPD, billing, lab, pharmacy and HMIS reports, built on Oracle APEX.

    • Modules
    • Technology
    • Security
    • User guide
    Get Rounds HMS Cloud-hosted
  • APEX 26.1 Book
    Inside the bookReal pages from the book
    Oracle APEX 26.1 · Book

    Oracle APEX 26.1: The Complete Guide

    Build a real app with reports, grids, security, workflows, REST and AI. 828 pages, paperback and Kindle.

    • What you learn
    • Six parts, 48 chapters
    • Inside the book
    • FAQ
    Get the book Paperback, Kindle & Apple Books
  • APEX API Book
    Inside the bookReal pages from the book
    Oracle APEX 26.1 · JavaScript & PL/SQL

    Oracle APEX 26.1 API by Example

    Every APEX JavaScript and PL/SQL API, 1,850+ methods, events, procedures and functions, each with a runnable example and real output.

    • Syntax, example, output
    • 32 everyday recipes
    • Three parts, 32 chapters
    • FAQ
    Get the book Paperback, Kindle & Apple Books
  • SQL & PL/SQL Book
    Inside the bookReal pages from the book
    Oracle AI Database 26ai · SQL & PL/SQL

    Oracle Database 26ai SQL and PL/SQL

    Every SQL function, statement and developer package of Oracle AI Database 26ai, with 677 examples and their real output.

    • Syntax, example, output
    • 677 examples
    • Eight parts, 66 chapters
    • FAQ
    Get the book Paperback, Kindle & Apple Books
  • Forms 14c Book
    Inside the bookReal pages from the book
    Oracle Forms 14.1.2 · Book

    Oracle Forms 14c: The Complete Developer's Guide

    Build and deploy Forms 14.1.2 apps, with 64 forms run in a real lab and every property, built-in and trigger shown.

    • Syntax, example, screen
    • What's new in 14c
    • Six parts, 40 chapters
    • FAQ
    Get the book Paperback, Kindle & Apple Books
  • Oracle AI Book
    Inside the bookReal pages from the book
    Oracle AI Database 26ai · APEX 26.1

    AI Applications with Oracle Database 26ai and APEX 26.1

    Build vector search, RAG and AI agents in SQL, PL/SQL and Oracle APEX, with 237 examples and their real output.

    • Syntax, example, output
    • 237 examples
    • Five parts, 29 chapters
    • FAQ
    Get the book Paperback, Kindle & Apple Books
How to Use AES-GCM Authenticated Encryption in Oracle
  • PLSQL

How to Use AES-GCM Authenticated Encryption in Oracle

Encrypt data and detect any change to it with AES-GCM, using an authentication tag and additional authenticated data.

  • Vinish Kapoor
  • October 5, 2026
How to Encrypt Data with DBMS_CRYPTO.ENCRYPT
  • PLSQL

How to Encrypt Data with DBMS_CRYPTO.ENCRYPT

Protect sensitive values with AES-256 encryption in PL/SQL, with random keys and a new initialization vector for every value.

  • Vinish Kapoor
  • October 5, 2026
How to Get Change Notifications with DBMS_CQ_NOTIFICATION
  • PLSQL

How to Get Change Notifications with DBMS_CQ_NOTIFICATION

Have Oracle call your PL/SQL procedure after committed changes to the tables a query reads, with the table, operation, and rows.

  • Vinish Kapoor
  • October 5, 2026
How to Signal Events with DBMS_ALERT
  • PLSQL

How to Signal Events with DBMS_ALERT

Let sessions wait for named events and wake them with a message that is delivered when the signaling transaction commits.

  • Vinish Kapoor
  • October 5, 2026
How to Send Messages Between Sessions with DBMS_PIPE
  • PLSQL

How to Send Messages Between Sessions with DBMS_PIPE

Send packed messages from one session to another through named pipes in memory, and keep a cached value in a singleton pipe.

  • Vinish Kapoor
  • October 5, 2026
How to Use Transactional Event Queues in Oracle
  • PLSQL

How to Use Transactional Event Queues in Oracle

Create a sharded, high-throughput event queue in one call, publish JSON events, and read them as a subscriber.

  • Vinish Kapoor
  • October 5, 2026
How to Add Queue Subscribers in Oracle
  • PLSQL

How to Add Queue Subscribers in Oracle

Deliver each queue message to several subscribers, filter what each receives with rules, and dequeue by consumer name.

  • Vinish Kapoor
  • October 5, 2026
How to Dequeue Messages with DBMS_AQ.DEQUEUE
  • PLSQL

How to Dequeue Messages with DBMS_AQ.DEQUEUE

Take messages off a queue in priority order, wait for new ones, filter by correlation ID, and browse without removing.

  • Vinish Kapoor
  • October 5, 2026
How to Enqueue Messages with DBMS_AQ.ENQUEUE
  • PLSQL

How to Enqueue Messages with DBMS_AQ.ENQUEUE

Add messages to a queue with priorities, correlation IDs, expiration, and delays, committed together with your data.

  • Vinish Kapoor
  • October 5, 2026
How to Create Queues with DBMS_AQADM
  • PLSQL

How to Create Queues with DBMS_AQADM

Create a queue table and a queue for your own message type, start it, and stop enqueuing or dequeuing separately.

  • Vinish Kapoor
  • October 5, 2026
How to Use DBMS_JOB in Oracle (legacy jobs)
  • PLSQL

How to Use DBMS_JOB in Oracle (legacy jobs)

Maintain old code that uses DBMS_JOB, see how its jobs become Scheduler jobs, and map each call to DBMS_SCHEDULER.

  • Vinish Kapoor
  • October 5, 2026
How to Build Job Chains with DBMS_SCHEDULER
  • PLSQL

How to Build Job Chains with DBMS_SCHEDULER

Run load, check, and report steps as one Scheduler job, with rules that start the next step on success or failure.

  • Vinish Kapoor
  • October 5, 2026
How to Handle Scheduler Job Failures in Oracle (job log, retries)
  • PLSQL

How to Handle Scheduler Job Failures in Oracle (job log, retries)

Find the error of a failed Scheduler job in the run log, and stop a job that keeps failing with the MAX_FAILURES attribute.

  • Vinish Kapoor
  • October 5, 2026
How to Create Scheduler Programs in Oracle (schedules, arguments)
  • PLSQL

How to Create Scheduler Programs in Oracle (schedules, arguments)

Define what to run as a program with arguments and when as a named schedule, and combine them in jobs with argument values.

  • Vinish Kapoor
  • October 5, 2026
How to Write Scheduler Calendar Expressions in Oracle
  • PLSQL

How to Write Scheduler Calendar Expressions in Oracle

Describe when Scheduler jobs repeat with FREQ, INTERVAL, and BY clauses, and test the run dates before you schedule anything.

  • Vinish Kapoor
  • October 5, 2026
How to Create Jobs with DBMS_SCHEDULER.CREATE_JOB
  • PLSQL

How to Create Jobs with DBMS_SCHEDULER.CREATE_JOB

Schedule PL/SQL to run nightly with one call, run it on demand to test it, check its runs, and stop or drop jobs.

  • Vinish Kapoor
  • October 5, 2026
How to Store Credentials with DBMS_CREDENTIAL
  • PLSQL

How to Store Credentials with DBMS_CREDENTIAL

Store user names and passwords in the database under a name, so PL/SQL code and jobs never contain the password itself.

  • Vinish Kapoor
  • October 5, 2026
How to Send E-mail with UTL_MAIL
  • PLSQL

How to Send E-mail with UTL_MAIL

Install UTL_MAIL and send e-mail from PL/SQL in one call, with copies, a MIME type, and a text or binary attachment.

  • Vinish Kapoor
  • October 5, 2026
Prev1 … 16 17 18 19 20 21 22 … 85Next
No more posts to load

Copyright © 2024-2026 - Vinish.Dev - and it is not affiliated with, nor sponsored by, Oracle Corporation.

  • Contact
  • Privacy Policy
  • Cookie Policy