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
Opportunity Funnel page with the report Opportunities That Reached Proposal below the funnel, title marked with a red box
  • Oracle APEX

How to Build a Funnel Chart in Oracle APEX

Prepare cumulative funnel numbers in a view, show them in an Oracle APEX Funnel chart with labels and tooltips, and list the records behind each section.

  • Vinish Kapoor
  • October 23, 2026
Mocha row being dragged above Espresso with a yellow placeholder row showing the drop position
  • Oracle APEX

How to Let Users Reorder Items by Drag and Drop in Oracle APEX

Add a drag handle to a classic report, reorder rows with jQuery UI Sortable, and save all positions in one MERGE that refuses outdated or forged lists.

  • Vinish Kapoor
  • October 23, 2026
Team Offsite selected after saving, with the task Book a venue and its two checklist items
  • Oracle APEX

How to Build a Three-Level Master-Detail Page with Interactive Grids in Oracle APEX

Chain three Interactive Grids with Master Region and Master Column, add a page Save button, and store a new parent with its children and grandchildren in one submit.

  • Vinish Kapoor
  • October 23, 2026
Grid with four new green rows LT-1002, PR-3001, PJ-4001 and MN-2002 and the footer 4 rows pasted, marked with red boxes
  • Oracle APEX

How to Paste Rows from Excel into an Interactive Grid in Oracle APEX

Copy spreadsheet rows into an editable Interactive Grid with Paste Insert, map names to IDs in a PL/SQL save process, and validate every pasted value.

  • Vinish Kapoor
  • October 23, 2026
Grid scrolled to the right with the frozen Reg No column at the left edge marked with a red box
  • Oracle APEX

How to Freeze Columns in an Interactive Grid in Oracle APEX

Keep key columns in view while users scroll a wide Interactive Grid: freeze from the column menu, save the default report, and keep personal layouts in private reports.

  • Vinish Kapoor
  • October 23, 2026
Grid with SJ-1006 to SJ-1008 all set to Carla Diaz, 11/05/2026, High and Scheduled marked with a red box
  • Oracle APEX

How to Fill Down and Copy Values in an Interactive Grid in Oracle APEX

Build an editable Interactive Grid that opens in cell selection mode, fill and copy values across many rows, lock finished rows, and validate the bulk changes on save.

  • Vinish Kapoor
  • October 22, 2026
Request Lines grid with three new unsaved rows Stapler, Sticky Notes Pack and Wireless Mouse marked with red boxes
  • Oracle APEX

How to Add Rows to an Interactive Grid from a Popup Selection in Oracle APEX

Build a multi-select popup with a row selector, return the ticked rows with Close Dialog, and insert or update grid rows through apex.model.

  • Vinish Kapoor
  • October 22, 2026
Expenses by Period page with Period This Month, Reference Date 2026-10-22 and six rows with a total of 372.25
  • Oracle APEX

How to Filter Reports by Relative Dates (This Week, Last Month) in Oracle APEX

Build a period filter with a SQL macro and a reference date, test every period at its boundaries, and add a Range facet with ranges that do not overlap.

  • Vinish Kapoor
  • October 22, 2026
Report headings Name, Job Title, Email and Phone marked with a red box
  • Oracle APEX

How to Let Users Choose Which Columns to Show in a Classic Report in Oracle APEX

Build a column chooser for a classic report, save each user's choice as a preference, render only ticked columns, and drop forged column names on submit.

  • Vinish Kapoor
  • October 22, 2026
Leave Requests report where only the four NEW rows show the employee name as a link, marked with red boxes
  • Oracle APEX

How to Show a Link Only for Some Rows in a Report in Oracle APEX

Add a conditional Edit link to a classic report and an interactive report, keep the checksum, refresh after the dialog, and recheck the rule on the server.

  • Vinish Kapoor
  • October 22, 2026
Issues report with the filters Priority = 'HIGH' and Status in 'OPEN, IN_PROGRESS' marked with a red box
  • Oracle APEX

How to Link to a Filtered Interactive Report from Another Page in Oracle APEX

Build a dashboard whose cards, links and buttons open one interactive report with ready-made filters, and learn the operators, RIR, comma and date rules.

  • Vinish Kapoor
  • October 22, 2026
Hover card for Northwind Traders with email, phone, city, segment, customer since, orders, total spent and last order marked with a red box
  • Oracle APEX

How to Show a Detail Popup When Hovering Over a Report Row in Oracle APEX

Build a hover card for a classic report with an Ajax Callback, a debounced script that ignores late replies, keyboard and touch support, escaping and a few CSS rules.

  • Vinish Kapoor
  • October 21, 2026
Work Progress interactive report with blue, green, orange and red progress bars and percentage labels
  • Oracle APEX

How to Show Progress Bars Inside Report Columns in Oracle APEX

Build progress and budget bars in an interactive report with threshold colors, capped widths, labels and ARIA attributes, then test sorting, filters, CSV and escaping.

  • Vinish Kapoor
  • October 21, 2026
Printed invoice INV-1001 on one A4 page with letterhead, Bill To, Invoice Details, Items, Totals and the thank-you footer
  • Oracle APEX

How to Make a Printable Page with Print CSS in Oracle APEX

Build an invoice page with a Print button, hide the header, menu and buttons on paper with @media print, add a print-only footer and keep totals together.

  • Vinish Kapoor
  • October 21, 2026
Account Statement page with the running balance of ACC-100 and three negative balances highlighted in red
  • Oracle APEX

How to Show a Running Balance in a Report in Oracle APEX

Calculate the balance after every row with an analytic SUM, show it in an Interactive Report, highlight negative values and keep users from sorting it out of order.

  • Vinish Kapoor
  • October 21, 2026
Aging Report page with the As Of Date, the stacked bar chart, the aging summary with Report Total row and the Open Invoices list
  • Oracle APEX

How to Show Aging Buckets (0-30, 31-60, 61-90 Days) in Oracle APEX

Group open balances by days past due with one SQL macro, a Classic Report with Compute Sum, a stacked bar chart and an As Of Date field.

  • Vinish Kapoor
  • October 21, 2026
Top 10 Leaderboard for the last 90 days with the two rank 3 rows and the two rank 10 rows marked with red boxes
  • Oracle APEX

How to Show a Top 10 Leaderboard in Oracle APEX

Rank scores with RANK instead of FETCH FIRST, show them in a Content Row with badges, avatars and bars, switch the period, and test ties and forged values.

  • Vinish Kapoor
  • October 21, 2026
Order DO-3001 expanded with its three order lines marked with a red box
  • Oracle APEX

How to Expand a Report Row to Show Its Details in Oracle APEX

Add an expand button to each report row, load the child rows on demand with an Ajax Callback, escape them safely, and test sorting, empty and invalid requests.

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