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
New purchase order with the success message and Copied From PO 1 marked with red boxes, status New and three copied lines
  • Oracle APEX

How to Copy a Master Record with All Its Detail Rows in Oracle APEX

Add a Copy with Lines button that inserts a new master row, copies every detail row with INSERT ... SELECT and opens the copy for editing.

  • Vinish Kapoor
  • October 16, 2026
Quote dialog with Discount % 10 and the red required marker on Discount Reason, marked with a red box
  • Oracle APEX

How to Make a Field Required Only When Another Field Has a Value in Oracle APEX

Toggle the required marker and attribute with a dynamic action, repeat the rule in a conditional validation and protect the table with a check constraint.

  • Vinish Kapoor
  • October 16, 2026
Feedback Entry dialog with 57 characters left below Headline and 76 of 500 below Comments, both marked with a red box
  • Oracle APEX

How to Show a Character Counter and Length Limit on a Text Area in Oracle APEX

Turn on the Textarea Character Counter, match Maximum Length to the column, add a server-side length validation and show characters left on a Text Field.

  • Vinish Kapoor
  • October 16, 2026
Room Bookings page with From 06-NOV-2026 and the To date picker open, days 1 to 5 November greyed out, both marked with red boxes
  • Oracle APEX

How to Add a From/To Date Range with Validation in Oracle APEX

Link two date pickers with Minimum and Maximum Item, add a server-side validation and a check constraint, and filter a classic report by an overlapping date range.

  • Vinish Kapoor
  • October 16, 2026
Meeting Note page with the Unsaved Draft alert, Restore Draft and Discard Draft buttons, marked with a red box above the empty form
  • Oracle APEX

How to Auto-Save a Form Draft and Restore It Later in Oracle APEX

Build server-side form drafts with a JSON draft table, a debounced dynamic action, a restore notice with Restore and Discard buttons, and a cleanup process.

  • Vinish Kapoor
  • October 16, 2026
Partner dialog with Partner Name North Wind Trading and the Possible Duplicates warning listing Northwind Traders, Seattle, score 92, marked with a red box
  • Oracle APEX

How to Warn About Possible Duplicate Records While Typing in Oracle APEX

Build a possible-duplicates warning with a virtual name key, Jaro-Winkler scores, a classic report in an Alert region and a debounced Key Release dynamic action.

  • Vinish Kapoor
  • October 16, 2026
Supplier Contact dialog with the notification 2 errors have occurred and the email and phone error messages below the fields
  • Oracle APEX

How to Validate Email and Phone Formats with Regular Expressions in Oracle APEX

Add regular expression validations, E-Mail and Phone Number subtypes, and matching REGEXP_LIKE check constraints, then test valid and invalid values.

  • Vinish Kapoor
  • October 15, 2026
Side navigation menu for demo_dev with Orders, Products, Billing and Administration groups and all their entries
  • Oracle APEX

How to Build the Navigation Menu from a Table in Oracle APEX

Create a MENU_ENTRIES table, turn it into a role-filtered dynamic list, use it as the navigation menu, and add an admin page to edit the entries.

  • Vinish Kapoor
  • October 15, 2026
Service Requests page after a new sign-in with Team Hardware and Status Open restored and marked with a red box
  • Oracle APEX

How to Remember Each User's Filters with Preferences in Oracle APEX

Set filter items to Per User (Persistent) storage, refresh the report with a dynamic action, add a Reset Filters button, and check the saved preferences in SQL.

  • Vinish Kapoor
  • October 15, 2026
Support Tickets page after the update with the new counts in the badge region marked with a red box
  • Oracle APEX

How to Create Your Own Template Component in Oracle APEX

Create a template component plug-in with Partial and Report templates, map its attributes, add CSS, and use it as a region and as a report column.

  • Vinish Kapoor
  • October 15, 2026
Progressive Web App page with Installable on and Display Standalone, Screen Orientation Portrait, custom Theme Color and Background Color marked with red boxes
  • Oracle APEX

How to Make an Oracle APEX App Installable as a Progressive Web App

Change the app icon, turn on Installable, set display mode, colors and short name, add a screenshot, and check the manifest, service worker and offline page.

  • Vinish Kapoor
  • October 15, 2026
Recycle Bin page with four deleted contacts, Days Left values, Restore buttons and red Delete Permanently buttons
  • Oracle APEX

How to Add a Recycle Bin with Soft Delete and Restore in Oracle APEX

Turn the form's Delete into a soft delete, build a Recycle Bin page with Restore and Delete Permanently, and purge rows after 30 days with an automation.

  • Vinish Kapoor
  • October 15, 2026
Invoices report with the new row INV-2026-0007 for Northwind Traders marked with a red box
  • Oracle APEX

How to Generate Gap-Free Document Numbers in Oracle APEX

Build a counter table and a numbering function, assign the number when an APEX form saves, and test rollbacks, concurrent users and a new year.

  • Vinish Kapoor
  • October 15, 2026
Orders by Status chart with the tooltip Series Orders Group NEW Value 36 and the NEW bar marked with a red box
  • Oracle APEX

How to Drill Down from a Chart to the Matching Rows in Oracle APEX

Build a bar chart and a report page, pass the clicked value or a hidden key through the series link, and test counts, cache clearing and checksums.

  • Vinish Kapoor
  • October 15, 2026
Product Cards page with the Office Chair card showing price 179 and a green highlight, marked with a red box
  • Oracle APEX

How to Edit Cards in a Drawer Without Reloading the Page in Oracle APEX

Build a Cards page and a drawer form, return the edited key, refresh the region on Dialog Closed, and test errors, Cancel and Delete.

  • Vinish Kapoor
  • October 15, 2026
Report with chips Status NEW, Order Total 2000 and more and Order Date 9/01/2026 to 9/30/2026 marked with a red box, showing orders 150 and 51
  • Oracle APEX

How to Add Smart Filters to a Report in Oracle APEX

Build a Smart Filters page step by step, add range filters with manual entry, compare search text with filter values, and check every count with SQL.

  • Vinish Kapoor
  • October 15, 2026
Catalog Items report showing 12 rows from the REST API with the Category select list above it
  • Oracle APEX

How to Show Data from a REST API in a Report in Oracle APEX

Publish an API with ORDS, create a REST Data Source, filter an Interactive Report through a URL parameter, and copy the rows into a local table.

  • Vinish Kapoor
  • October 14, 2026
Thread of order 150 as SALES_USER with four comments and a Delete link only on the SALES_USER comment, marked with a red box
  • Oracle APEX

How to Add a Comments Thread to Orders in Oracle APEX

A comments table with declarative defaults, the Comments page wizard, a new comment form, and a Delete action that the server limits to the author.

  • Vinish Kapoor
  • October 14, 2026
Prev1 … 3 4 5 6 7 8 9 … 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