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
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
Meeting Booking dialog with the error This room is already booked from 16-NOV-2026 09:00 to 10:30 (Sprint Planning) below Start Time, marked with a red box
  • Oracle APEX

How to Prevent Overlapping Bookings in Oracle APEX

Check new bookings against saved ones with a validation, allow back-to-back slots, and lock the room row so two users saving at once cannot double-book.

  • Vinish Kapoor
  • October 17, 2026
Service Order dialog for SO-1001 as order_editor with the Status list New (current) and Cancelled, marked with a red box
  • Oracle APEX

How to Allow Only Valid Status Changes with a Transition Table in Oracle APEX

Store allowed status moves per role in a table, show only the next valid statuses in the form select list, and reject forced values with a validation.

  • Vinish Kapoor
  • October 17, 2026
Popup LOV with the search text audio and three results Electronics > Audio, Headphones and Speakers, marked with a red box
  • Oracle APEX

How to Pick a Category from a Hierarchical Select List in Oracle APEX

Build an indented select list and a searchable Popup LOV from a self-referencing category table with CONNECT BY, save the ID and show full paths in reports.

  • Vinish Kapoor
  • October 17, 2026
Stock Item dialog with the name laptop and the message Another item already uses this name, marked with a red box
  • Oracle APEX

How to Enforce Case-Insensitive Unique Names with a Friendly Message in Oracle APEX

Use a unique index on upper(trim(name)), a declarative validation and a page error handling function to stop near duplicate names with a clear message.

  • Vinish Kapoor
  • October 17, 2026
Credit Limit Warning dialog with the balance and limit text and the Go Back and Save Anyway buttons, marked with a red box
  • Oracle APEX

How to Show Warnings That Still Allow Saving in Oracle APEX

Check a soft rule on the server, ask the user with a declarative Confirm dialog, record the answer in a hidden item and keep hard errors as real validations.

  • Vinish Kapoor
  • October 17, 2026
Visitor Pass dialog with all required fields filled and the enabled Create button marked with a red box
  • Oracle APEX

How to Disable the Save Button Until All Required Fields Are Filled in Oracle APEX

Check the required items with a custom input change event and a JavaScript condition, switch the buttons with Enable and Disable actions, and keep server checks.

  • Vinish Kapoor
  • October 17, 2026
Survey Results page with Chart Question Which session was the most useful? marked with a red box and bars for SQL Basics 0, Page Designer 1, Dynamic Actions 2 and REST Data Sources 1
  • Oracle APEX

How to Build a Survey Form from Question Tables in Oracle APEX

Store surveys, questions and options in tables, draw the form with a Dynamic Content region, validate the answers on the server and show the results in a chart.

  • Vinish Kapoor
  • October 17, 2026
Asset dialog for AST-1002 with the Custom Fields grid marked with a red box: Serial Number, Color White, Purchase Cost and Warranty Until
  • Oracle APEX

How to Let Users Add Custom Fields to a Record in Oracle APEX

Store field definitions and values in two tables, edit them with an Interactive Grid on the form, validate each type and block saves with missing required values.

  • Vinish Kapoor
  • October 17, 2026
Hotel Room dialog for room 103 with Has Sea View On and Pets Allowed Yes marked with red boxes
  • Oracle APEX

How to Use the BOOLEAN Data Type in Forms and Reports in Oracle APEX

Build a report and form on BOOLEAN columns, keep NULL values safe, give new records the right default, and filter reports by Yes or No.

  • Vinish Kapoor
  • October 17, 2026
Order Document form for WO-1001 with the Stored Document region showing the JSON document
  • Oracle APEX

How to Build a Form on a JSON Relational Duality View in Oracle APEX

Edit order documents stored in relational tables through a duality view, keep read-only client data safe, and stop saves after another session changed the document.

  • Vinish Kapoor
  • October 17, 2026
Device form for ProBook 14 with Color Space Gray and Warranty Months 36 marked with red boxes
  • Oracle APEX

How to Edit JSON Column Data in a Form in Oracle APEX

Build a report and a form on a 26ai JSON column with a JSON Source, edit attributes as normal fields, and learn what APEX writes for empty values.

  • Vinish Kapoor
  • October 17, 2026
Lookup Values page for ORDER_EDITOR with the values sorted by Sequence
  • Oracle APEX

How to Manage All Lookup Values from One Page in Oracle APEX

Keep every short list in two lookup tables, maintain them on one master-detail page, and use shared lists of values that hide retired values but keep old records.

  • Vinish Kapoor
  • October 17, 2026
Knowledge Article dialog for ORDER_EDITOR with the Being Edited notice marked with a red box, read-only fields and only the Cancel button
  • Oracle APEX

How to Lock a Record While a User Is Editing It in Oracle APEX

Build a checkout lock with a lock table and a small package, show other users a read-only form with the editor's name, and release the lock on save, cancel or expiry.

  • Vinish Kapoor
  • October 16, 2026
Store Order dialog for a shipped order with the Read-Only Order notice marked with a red box and only the Cancel button
  • Oracle APEX

How to Make a Whole Form Read-Only Based on the Record's Status in Oracle APEX

Use the page Read Only condition with a status query, hide Save and Delete, show a notice, and add a validation that blocks forced SAVE and DELETE requests.

  • Vinish Kapoor
  • October 16, 2026
Team Tasks report with the On Hold badge of Renew software licenses now red
  • Oracle APEX

How to Add a Color Picker and Show Colored Status Badges in Oracle APEX

Use a Color Picker item with preset colors and a contrast check, a virtual column for the text color, and an HTML Expression that turns report columns into badges.

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