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
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
Version History with versions 3, 2 and 1, version 3 Current, success message Version 3 saved.
  • Oracle APEX

How to Keep a Version History for Uploaded Documents in Oracle APEX

Store each upload as a numbered version, lock the document while numbering, list all versions with download links and let editors make an older version current.

  • Vinish Kapoor
  • October 20, 2026
Client 360 page for Asha Textiles with the key figures cards marked with a red box: 4 orders, 271,750 revenue, last order 06-Oct-2026, 1 open order, 3 notes, 2 files
  • Oracle APEX

How to Build a 360 View Page That Combines Related Data in Oracle APEX

Combine a Content Row header, Cards with correct per-record figures and a Region Display Selector with related reports, plus an edit dialog.

  • Vinish Kapoor
  • October 20, 2026
Nearest Stores report with Connaught Place 3.13 km, Saket 13.37 km and Dwarka 15.03 km marked with a red box, and the map with the customer, three stores and dashed lines
  • Oracle APEX

How to Find the Nearest Locations on a Map in Oracle APEX

Rank locations by distance with SDO_NN and a spatial index, then show the nearest three in a report and on a map centered on the customer.

  • Vinish Kapoor
  • October 19, 2026
Cart after the update with Ceramic Mug 3 and A5 Notebook 2 and Cart Total 49.00 marked with red boxes
  • Oracle APEX

How to Build a Shopping Cart with APEX Collections in Oracle APEX

An APEX collection holds the cart per session, cards add products, an editable grid changes quantities, and a checkout turns the cart into an order.

  • Vinish Kapoor
  • October 19, 2026
Quantity to Build 10 marked with a red box and the tree showing CH-100 Office Chair build 10 and Wheel 100 EA in total
  • Oracle APEX

How to Show a Bill of Materials with Exploded Quantities in Oracle APEX

A recursive WITH query multiplies quantities through every level, a tree and two reports show the structure and parts to order, and a trigger refuses loops.

  • Vinish Kapoor
  • October 19, 2026
Poll page after voting with the success message, Your Vote Tuesday, Total Votes 4 and a bar chart with Tuesday 2 at 50 percent, Wednesday 2 at 50 percent, Thursday 0 and Friday 0
  • Oracle APEX

How to Build a Poll with One Vote per User and a Results Chart in Oracle APEX

A unique key, a page error handling function and a bar chart that appears only after the user votes or the poll closes.

  • Vinish Kapoor
  • October 19, 2026
Bulk Price Update page with the success message and the Preview region with four products marked with a red box
  • Oracle APEX

How to Update Records in Bulk with a Preview Before Saving in Oracle APEX

Filters, a preview report of old and new values, and an Apply button that runs one UPDATE only if the data still matches the preview.

  • Vinish Kapoor
  • October 19, 2026
My Work page of ORDER_EDITOR with the counts 3, 0 and 0 and the three assigned orders marked with red boxes
  • Oracle APEX

How to Assign Records to Users and Show "My Work" in Oracle APEX

Bulk assignment with a shuttle, a My Work page filtered by APP_USER, and a PL/SQL package that enforces who may assign, take and release work.

  • Vinish Kapoor
  • October 19, 2026
Order Checklist page with SO-1002 at 3 of 3 steps, a full bar and the Complete badge marked with a red box
  • Oracle APEX

How to Add a Checklist with Progress to Each Record in Oracle APEX

Copy template steps to each new record, tick them with checkboxes saved by a dynamic action, and show progress with a Percent Graph and a Complete badge.

  • Vinish Kapoor
  • October 18, 2026
Work Queue page with the message Ticket 5 is now yours, ticket 5 In Progress with a Mark Done link and five waiting tickets
  • Oracle APEX

How to Build a Work Queue with "Take Next" Using SKIP LOCKED in Oracle APEX

Read the queue in priority order with a SKIP LOCKED cursor, give each user the next free job, allow one open job per user and close it with Mark Done.

  • Vinish Kapoor
  • October 18, 2026
Event Registration page with the message The event is full. You are on the waitlist and a Waitlisted registration with position 1
  • Oracle APEX

How to Build an Event Registration with Seat Limits in Oracle APEX

Count seats against a capacity, add a waitlist when an event is full, promote the first waiting user on cancel, and lock the row so no seat is sold twice.

  • Vinish Kapoor
  • October 18, 2026
Merge Customers page with Northwind Traders 1 and North Wind Traders Ltd 2 picked, the Compare report and the merge history
  • Oracle APEX

How to Merge Duplicate Records in Oracle APEX

Pick the record to keep and the duplicate, compare them side by side, move the child rows with a locking PL/SQL procedure, mark the duplicate as merged and log it.

  • Vinish Kapoor
  • October 18, 2026
Stock Levels page with badges 5 Items, 2 Low Stock, 2 Out of Stock and the report with red and yellow highlighted rows
  • Oracle APEX

How to Track Stock Movements and Low-Stock Alerts in Oracle APEX

Record receipts and issues as movements, calculate stock on hand in a view, block issues beyond the stock with a locking validation, and highlight low stock.

  • Vinish Kapoor
  • October 18, 2026
Weekly Timesheet after saving with the success message Timesheet saved. and updated totals
  • Oracle APEX

How to Build a Weekly Timesheet Entry Grid in Oracle APEX

Pivot daily rows into Monday to Sunday columns, save the interactive grid with PL/SQL code, add row and day totals, and block more than 24 hours per day.

  • Vinish Kapoor
  • October 18, 2026
Webinars report in a New York browser with Show Times In America/New_York and the Your Local Time column marked with red boxes
  • Oracle APEX

How to Show Dates and Times in Each User's Time Zone in Oracle APEX

Store times as TIMESTAMP WITH LOCAL TIME ZONE, turn on Automatic Time Zone, show local, presenter and UTC times, and let users pick another time zone.

  • Vinish Kapoor
  • October 18, 2026
Expense Claim dialog with Spent On 16-OCT-2026, Currency Euro, Amount 230 and In Base Currency 1 EUR = 1.101 USD (rate of 15-OCT-2026), 253.23 USD marked with a red box
  • Oracle APEX

How to Handle Multi-Currency Amounts with Exchange Rates in Oracle APEX

Store exchange rates by date, convert each amount with the rate of its day, preview it in the form, block missing rates and total in the base currency.

  • Vinish Kapoor
  • October 18, 2026
Support Case dialog with Received On 25-NOV-2026 and Due On 30-NOV-2026 marked with a red box
  • Oracle APEX

How to Calculate Due Dates in Business Days, Skipping Holidays in Oracle APEX

Build a holiday table and a PL/SQL business-day function, show the due date while typing, save it with a server computation, and report business days left.

  • Vinish Kapoor
  • October 18, 2026
Event Calendar for November 2026 with weekly meetings on Mondays and Sprint Review on 5 and 19 November; the meeting on 16 November is marked with a red box
  • Oracle APEX

How to Generate Recurring Events (Weekly, Monthly) in Oracle APEX

Store the repeat rule once, generate the dates with DBMS_SCHEDULER, show them on a calendar, and move or cancel single dates without losing them later.

  • Vinish Kapoor
  • October 18, 2026
1 2 3 4 … 82Next
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