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
Sign-in page showing This account is locked. Try again in 15 minute(s) or ask an administrator to unlock it. and Please wait 25 seconds to sign in again.
  • Oracle APEX

How to Lock a User Account After Failed Login Attempts in Oracle APEX

Use the built-in lockout, build a failed counter and lock time for custom accounts, and add an administrator page that unlocks them.

  • Vinish Kapoor
  • October 26, 2026
My Profile page for demo_dev showing Welcome, Priya Nair, Department Engineering, Region North and two North leads in the report
  • Oracle APEX

How to Load the User's Profile into Application Items After Login in Oracle APEX

Fill application items once after login with After Authentication computations, use them in titles and queries, and block changes from the URL.

  • Vinish Kapoor
  • October 26, 2026
Photo Gallery page after the upload with the message Photos uploaded, the carousel with dusk.jpg and a gallery of three cards
  • Oracle APEX

How to Build a Photo Gallery with a Carousel in Oracle APEX

Upload many pictures into a BLOB table, show them in a Cards grid and a Carousel Container, open them in full size and reject files that are not images.

  • Vinish Kapoor
  • October 26, 2026
Content Row region with six team members, each with a status badge and a circular avatar with initials
  • Oracle APEX

How to Use the Built-in Avatar and Badge Template Components in Oracle APEX

Show initials, photos and colored status badges from query columns with the Avatar and Badge template components, and handle missing photos and invalid states.

  • Vinish Kapoor
  • October 26, 2026
Only the payment methods answer is open, marked with a red box; the return answer is closed
  • Oracle APEX

How to Build an FAQ Page with Collapsible Answers from a Table in Oracle APEX

Show FAQ answers as collapsible details elements in a classic report, group them by category, add a search field, and keep stored HTML from running code.

  • Vinish Kapoor
  • October 26, 2026
Actions menu of SC-1005 for an administrator showing Email Vendor, Activate, a separator and Delete, Delete marked with a red box
  • Oracle APEX

How to Add Row Action Menus to Reports in Oracle APEX

Build a three-dot Actions menu on Content Row reports, show entries by status and role, run PL/SQL without a reload, and confirm before deleting.

  • Vinish Kapoor
  • October 25, 2026
Repair Tracker for ticket 3 with Received, Diagnosed and Repaired complete and Cancelled shown in red as the active step
  • Oracle APEX

How to Show a Status Progress Tracker in Oracle APEX

Build a tracker from a dynamic list query and the Wizard Progress template, move records to the next step, and show cancelled records in red.

  • Vinish Kapoor
  • October 25, 2026
Recently Viewed with the Git Workflow row at the top, Viewed 2 seconds ago and Views 2, marked with a red box
  • Oracle APEX

How to Show Recently Viewed Records in Oracle APEX

Store per-user page views in one table with a MERGE in a Before Header process, and show each user's last 10 viewed records with a classic report in Oracle APEX.

  • Vinish Kapoor
  • October 25, 2026
Course Catalog with the Dynamic Actions in Depth row, now with a gold star and Saved By 1, marked with a red box
  • Oracle APEX

How to Let Users Mark Records as Favorites in Oracle APEX

Store per-user favorites in one table, toggle a star in each report row with an Ajax Callback, and filter the report to the current user's favorites in Oracle APEX.

  • Vinish Kapoor
  • October 25, 2026
Notifications drawer with the unread Munich approval marked New and a red box, and the older read Berlin notification below
  • Oracle APEX

How to Build a Notification Bell with an Unread Count in Oracle APEX

Store per-user notifications, show the unread count on a navigation bar bell, list them in an Inline Drawer and mark them as read with Ajax in Oracle APEX.

  • Vinish Kapoor
  • October 25, 2026
Home page with a Planned downtime on Sunday warning and a New report available info banner, with the Dismiss button of the warning marked with a red box
  • Oracle APEX

How to Show a Dismissible Announcement Banner to All Users in Oracle APEX

Store announcements with start and end dates, show them on every page from the Global Page with the Alerts template, and let each user dismiss them in Oracle APEX.

  • Vinish Kapoor
  • October 25, 2026
Assigned to Me page for DEMO_DEV with three open requests and the menu entries Assigned to Me 3 and Request Queue 4 marked with red boxes
  • Oracle APEX

How to Show Badge Counts on Navigation Menu Entries in Oracle APEX

Add per-user and shared counts to the side navigation menu with restricted application items, Before Header computations and square-bracket labels in Oracle APEX.

  • Vinish Kapoor
  • October 24, 2026
Ticket Summary page with the Counted At column of Tickets by Desk and the Cache Status text marked with red boxes
  • Oracle APEX

How to Cache a Slow Region with Region Caching in Oracle APEX

Cache a shared summary and a per-user list with Server Cache, show the cache date, purge it with APEX_REGION, and avoid cached buttons in Oracle APEX.

  • Vinish Kapoor
  • October 24, 2026
Shipping Dashboard half a second after opening, with Key Figures loaded and the Shipments by Warehouse and Daily Shipments regions showing a spinner, both marked with red boxes
  • Oracle APEX

How to Speed Up a Dashboard with Lazy Loading Regions in Oracle APEX

Turn on Lazy Loading for a slow report, compare page load times before and after in the activity log, and see what a failing lazy region shows in Oracle APEX.

  • Vinish Kapoor
  • October 24, 2026
Visits Dashboard with From 2026-10-01 and To 2026-10-10 marked with a red box, a bar chart for ten days and the totals for this range
  • Oracle APEX

How to Let Users Pick a Date Range and Chart Type on a Dashboard in Oracle APEX

Add date pickers that refresh a chart and a report, a chart type switch that keeps the user's choice, and checks for wrong or forged ranges in Oracle APEX.

  • Vinish Kapoor
  • October 24, 2026
Chart with the tooltip Oct 2026 to date: 50,582 | Oct 2025 same days: 48,320 | +4.7% over the October point
  • Oracle APEX

How to Compare This Year with Last Year in a Chart in Oracle APEX

Build an Oracle APEX line chart that compares each month with the same month last year, with percentage tooltips, a fair current month and empty months shown as 0.

  • Vinish Kapoor
  • October 24, 2026
Heat map of requests by day and hour for all channels with dark cells on Monday morning and a legend from 0 to 25-33
  • Oracle APEX

How to Build a Heat Map by Day and Hour in Oracle APEX

Show counts by weekday and hour as a colored grid in Oracle APEX, with every empty hour shown as 0, a legend, a channel filter and checks against SQL.

  • Vinish Kapoor
  • October 24, 2026
Chart with the tooltip Actual: 52,500, Target: 47,000, 111.7% of target over the July bar
  • Oracle APEX

How to Show Actual vs Target in a Combination Chart in Oracle APEX

Build an Oracle APEX combination chart with actuals as green or red bars and the monthly target as a line, with filters and months without data shown as 0.

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