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
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
Oracle APEX Search results for contact 12 with the customer Contact 12 and orders 13, 53, 93 and 122 with status badges
  • Oracle APEX

How to Search Across Several Tables from One Search Page in Oracle APEX

Create search configurations for several tables, link each result to its record, and search them all from one search page.

  • Vinish Kapoor
  • October 13, 2026
Oracle APEX Orders and Lines page with order 13 selected in the top grid and its two lines, Monitor 27 and Docking Station, in the bottom grid
  • Oracle APEX

How to Build an Orders and Order Lines Master-Detail Page in Oracle APEX

Create a stacked master-detail page, see how the grids are linked, make the IDs readable, and test that new lines get the order ID.

  • Vinish Kapoor
  • October 13, 2026
Oracle APEX calendar for October 2026 with green deliveries, blue meetings and an orange multi-day APEX training
  • Oracle APEX

How to Build a Calendar Page with Drag-and-Drop Events in Oracle APEX

Show table rows as calendar events, color them by type, and let users move events to another day with drag and drop.

  • Vinish Kapoor
  • October 13, 2026
Oracle APEX Product form with inline help under Name and Price, the placeholder Pick or type a category, and a help icon next to Price, each marked with a red box
  • Oracle APEX

How to Add Help Text and Inline Hints to Form Fields in Oracle APEX

Guide users on a form with inline help under fields, longer help text behind a help icon, and value placeholders in empty fields.

  • Vinish Kapoor
  • October 12, 2026
Oracle APEX Product form with the new category Cameras typed into the Category field
  • Oracle APEX

How to Let Users Add a New Value from a Popup LOV in Oracle APEX

Turn on Manual Entry for a Popup LOV, add typed values to the lookup table on save, and avoid duplicates in different spellings.

  • Vinish Kapoor
  • October 12, 2026
Oracle APEX Products report with image thumbnails for Laptop Pro 14 and Monitor 27
  • Oracle APEX

How to Upload an Image and Show It in a Form and a Report in Oracle APEX

Store product images in a BLOB column with an Image Upload item, and show them as thumbnails in a report with a Display Image column.

  • Vinish Kapoor
  • October 12, 2026
Oracle APEX Product form with name Monitor 27 Pro, category Displays and price 390, and only the Create button
  • Oracle APEX

How to Copy an Existing Record into a New Form in Oracle APEX

Add a Copy button that reopens the form as a new record with the current values, so users change only what differs and save with Create.

  • Vinish Kapoor
  • October 12, 2026
Oracle APEX Product form for Webcam HD showing Created By ORDER_EDITOR, Updated By DEMO_DEV and the two timestamps, marked with a red box
  • Oracle APEX

How to Add Audit Columns (Created By, Updated By) Automatically in Oracle APEX

Add audit columns to a table, fill them with a trigger that records the APEX user, show them on a form, and test changes from APEX and SQL.

  • Vinish Kapoor
  • October 14, 2026
  • 2 Comments
Oracle APEX New Note form with a title and a rich text note with bold Customer 8 and a bulleted list
  • Oracle APEX

How to Add a Rich Text Editor and Store the HTML Safely in Oracle APEX

Add a rich text editor to a page, clean its HTML on the server with an allowlist, and show it in a report that cannot run scripts.

  • Vinish Kapoor
  • October 12, 2026
Oracle APEX error Session state protection violation: This may be caused by manual alteration of a URL containing a checksum or by using a link with an incorrect or missing checksum
  • Oracle APEX

How to Protect Oracle APEX Pages from URL Tampering

See a changed order ID open another record, then block it with checksums at page and item level, and find unprotected pages with a query.

  • Vinish Kapoor
  • October 12, 2026
Oracle APEX Login History page with an Active Users report listing DEMO_DEV and SALES_USER and a Login History report with successful and failed sign-ins
  • Oracle APEX

How to Show Login History and Active Users in Oracle APEX

Build an admin page with the active users of the last 30 minutes and every sign-in attempt with its result, from the logs APEX already keeps.

  • Vinish Kapoor
  • October 12, 2026
Oracle APEX dialog Your session will end at 14:06:22. Would you like to extend it? with Cancel and Extend buttons over the Sales Dashboard
  • Oracle APEX

How to Warn Users Before Their Session Times Out in Oracle APEX

Set the idle time and the timeout warning, see the Extend dialog and the end-of-session dialog, and test that Extend keeps the session alive.

  • Vinish Kapoor
  • October 12, 2026
Oracle APEX maintenance page showing Scheduled maintenance, APEX Solutions is being updated and will be back at 18:00 UTC
  • Oracle APEX

How to Put an Oracle APEX Application in Maintenance Mode

Close an APEX application for users while developers test, show a styled maintenance message, and switch it back from App Builder or a script.

  • Vinish Kapoor
  • October 12, 2026
Oracle APEX Sales Dashboard with four KPI cards for Orders, Revenue, Awaiting Approval and Customers, a Revenue by Month bar chart, an Orders by Status donut chart and a Top Products bar chart
  • Oracle APEX

How to Build a Dashboard Page with KPI Cards and Charts in Oracle APEX

Create a dashboard page, add KPI cards with icons from a single query, and replace the wizard's sample charts with charts on your own tables.

  • Vinish Kapoor
  • October 12, 2026
Oracle APEX Content Row report of new orders with orders 1, 2 and 11 checked and highlighted
  • Oracle APEX

How to Process Selected Report Rows with Checkboxes in Oracle APEX

Add checkboxes to a Content Row report with Row Selection, collect the selected keys in a page item, and approve the chosen orders in one process.

  • Vinish Kapoor
  • October 12, 2026
Oracle APEX Interactive Grid with the Quantity cell 0 marked in red and the error Quantity must be between 1 and 100
  • Oracle APEX

How to Validate Interactive Grid Rows Before Saving in Oracle APEX

Add row validations to an editable Interactive Grid, catch duplicate products per order, and see where a database constraint must take over.

  • Vinish Kapoor
  • October 12, 2026
Oracle APEX Upload Employees page showing the loaded file name and a preview of the six employees from the workbook
  • Oracle APEX

How to Let Users Upload an Excel File and Load It into a Table in Oracle APEX

Create a Data Load Definition from a sample workbook, map its columns, and add a page where users upload, preview, and load Excel data.

  • Vinish Kapoor
  • October 12, 2026
Oracle APEX wizard step Experience with position, years of experience, company and skills filled in
  • Oracle APEX

How to Build a Multi-Step Wizard Form in Oracle APEX

Split a long form into steps with a progress list, keep values between pages, review them, and save everything at the last step.

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