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
Product History page with LED Desk Lamp selected and three timeline entries: Updated by DEMO_DEV with the name and price change, Updated by ORDER_EDITOR with the price change, and Created by DEMO_DEV
  • Oracle APEX

How to Show a Record's Change History as a Timeline in Oracle APEX

Keep every row version with Flashback Data Archive, compare versions in a view, and show the changes with the Timeline report template.

  • Vinish Kapoor
  • October 14, 2026
Order Board page with four columns New, Approved, Shipped and Cancelled, each with order cards and a count
  • Oracle APEX

How to Build a Kanban Board for Order Status in Oracle APEX

Columns from a status table, cards from a Dynamic Content region, drag and drop with SortableJS, and a server-side check of every move.

  • Vinish Kapoor
  • October 14, 2026
Grid row Mouse with Quantity 8 and Amount 200.00 marked with red boxes, Current Total 3,676.00 marked with a red box, and Overall Sum still 3,601.00 marked with a red box
  • Oracle APEX

How to Show Totals and Calculated Columns in an Interactive Grid in Oracle APEX

A virtual column for the amount, a Set Value dynamic action in the browser, an IG aggregate in the footer, and a live total that updates before you save.

  • Vinish Kapoor
  • October 14, 2026
New grid row with Category Audio, Product Headset and Quantity 4 marked with a red box
  • Oracle APEX

How to Use Cascading Select Lists in an Interactive Grid in Oracle APEX

Make a grid column's list depend on another column of the same row, clear it when the parent changes, and keep each pair valid with a composite key.

  • Vinish Kapoor
  • October 14, 2026
  • 3 Comments
Product Tags page with the message Row created. Tags saved. and the new Wireless Earbuds row with New Arrival, Wireless marked with a red box
  • Oracle APEX

How to Save a Multi-Select into a Junction Table in Oracle APEX

Create a junction table with keys, load the saved tags into a Checkbox Group, sync only the changes on save, validate forced values, and list tags with LISTAGG.

  • Vinish Kapoor
  • October 14, 2026
Workflow Designer diagram of Order Fulfillment from Start through Large order? to Manager approval and Approved? or Approve automatically, then Packing time, Ship order and End
  • Oracle APEX

How to Automate an Order Process with Workflow in Oracle APEX

Design a workflow with switches, a human task, a wait, and code activities, start it from a page, and follow each order through it.

  • Vinish Kapoor
  • October 14, 2026
Oracle APEX Gantt chart Project Plan with six tasks, weekly labels, progress in Design and Content Writing, and dependency arrows
  • Oracle APEX

How to Build a Gantt Chart for Project Tasks in Oracle APEX

Create task tables, build a Gantt chart with the wizard, fix its timeline and progress, and draw the dependencies between tasks.

  • Vinish Kapoor
  • October 13, 2026
Oracle APEX Customer Map with blue markers for customers in North America, South America, Europe and India
  • Oracle APEX

How to Show Customers on a Map with Popups in Oracle APEX

Add coordinates to customers, create a map page with the wizard, and show each customer's city and orders in a popup.

  • Vinish Kapoor
  • October 13, 2026
Files of the Order report with package-photo.png and delivery-note-12.pdf uploaded by ORDER_EDITOR, with Download and Delete links, and the message Files uploaded.
  • Oracle APEX

How to Attach Files to Orders in Oracle APEX

Create an attachments table, upload many files at once with type and size limits, list them with download links, and delete them with confirmation.

  • Vinish Kapoor
  • October 13, 2026
Oracle APEX Sales Dashboard with the cards 155 Orders and 43 Awaiting Approval and the Orders by Status donut with NEW 43, marked with red boxes
  • Oracle APEX

How to Auto-Refresh a Dashboard Region Without Reloading the Page in Oracle APEX

Set the automatic refresh interval of charts, refresh a Cards region with a timer, and keep a dashboard current without page reloads.

  • Vinish Kapoor
  • October 13, 2026
Request Order Approval page in German with the navigation menu Startseite, Bestellpositionen and others, the title Bestellfreigabe anfordern, the item Bestellung, the button Freigabe anfordern and the report Meine Freigabeanfragen
  • Oracle APEX

How to Translate an Oracle APEX Application into Another Language

Convert the texts to text messages, add German, translate a CSV export, import it, and switch languages from the navigation bar.

  • Vinish Kapoor
  • October 13, 2026
My Approvals for DEMO_DEV with the Approvals 3 badge in the navigation bar and three Unassigned tasks, with the badge and the Claim button of order 20 marked with red boxes
  • Oracle APEX

How to Show "My Pending Approvals" with the Unified Task List in Oracle APEX

Create My Approvals and My Requests task list pages, add a pending count badge to the navigation bar, and share tasks between two approvers.

  • Vinish Kapoor
  • October 13, 2026
Task Details drawer for Approve order 10 for Customer 31 with the Order Lines report and the Reject and Approve buttons marked with a red box
  • Oracle APEX

How to Build an Approval Flow for Orders with Human Tasks in Oracle APEX

Create an approval task definition, request approval from a page, let administrators approve or reject in a task list, and update the order.

  • Vinish Kapoor
  • October 13, 2026
Change Password page with the error Use at least 12 characters, with upper and lower case letters and a digit. under the New Password field, marked with a red box
  • Oracle APEX

How to Let Users Change Their Own Password in Oracle APEX

Build a change password page step by step with validations for the current password, matching entries and strong rules, and link it from the user menu.

  • Vinish Kapoor
  • October 13, 2026
Oracle APEX Product form for a reader with all fields shown as read-only text and no save buttons
  • Oracle APEX

How to Hide Buttons and Regions Based on the User's Role in Oracle APEX

Use authorization schemes on buttons, make forms read-only for readers, and set edit authorization so hidden buttons cannot be bypassed.

  • Vinish Kapoor
  • October 13, 2026
Application Access Control page with the roles Administrator, Editor and Reader, one user each, and the user role assignments DEMO_DEV Administrator, ORDER_EDITOR Editor and SALES_USER Reader
  • Oracle APEX

How to Give Users Roles (Admin, Editor, Reader) with Access Control in Oracle APEX

Define roles, assign users, create authorization schemes for the roles, and protect a page so only administrators can open it.

  • Vinish Kapoor
  • October 13, 2026
Oracle APEX Order Cleanup Settings page with 30 days selected, marked with a red box, the message Setting saved. and 36 orders the next run will cancel
  • Oracle APEX

How to Store Configuration Values with Application Settings in Oracle APEX

Create an application setting with valid values, read it in SQL and PL/SQL, change it from an admin page, and keep it when you reinstall.

  • Vinish Kapoor
  • October 13, 2026
Create Automation wizard with name Cancel unapproved orders, Type Scheduled, Actions initiated on Query and Execution Schedule Daily at Midnight marked with red boxes
  • Oracle APEX

How to Run a Scheduled Task with Automations in Oracle APEX

Create a scheduled automation step by step, write its PL/SQL action, activate it, run it once, and check the automation log.

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