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
Oracle Forms search form with a Patient 1 of 15 counter below the records while the status line shows Record 1/?
  • Oracle Forms

How to Show a Record Count Before Scrolling in Oracle Forms

Count the records of a query before it runs in Oracle Forms 14.1.2 and show users where they are, without waiting for the last row to be fetched.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms search panel listing the patients of Pune sorted by birth date
  • Oracle Forms

How to Sort a Block by Clicking Column Headings in Oracle Forms

Turn column headings into sort buttons in Oracle Forms 14.1.2, with a second click that reverses the order and an arrow on the sorted column.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms billing form with a second payment of 42.50 added to invoice 3852
  • Oracle Forms

How to Update a Parent Record from POST-INSERT in Oracle Forms

Keep a parent record in step with its detail rows in Oracle Forms 14.1.2, in one transaction, and show the change without locking errors.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms appointments form opened for the patient chosen in the patients form
  • Oracle Forms

How to Refresh an Open Form with WHEN-FORM-NAVIGATE

Bring an open Oracle Forms 14.1.2 form to the front and let it catch up with a record chosen in another form, instead of opening a second copy.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms dashboard for a receptionist with today's figures, a half gauge at 83 percent, and Invoices disabled
  • Oracle Forms

How to Build a Dashboard Form in Oracle Forms

Give an Oracle Forms 14.1.2 application a home screen of the day's figures that refreshes on return and shows each role what it may open.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms sign-in form with the user RECEPTION1 chosen and a Sign In button
  • Oracle Forms

How to Build a Sign-In Form in Oracle Forms

Let users sign in to an Oracle Forms 14.1.2 application once, with their role shared by every form they open afterwards.

  • Vinish Kapoor
  • September 28, 2026
How to Export Any Block to CSV in Oracle Forms
  • Oracle Forms

How to Export Any Block to CSV in Oracle Forms

Write one procedure that exports any block to a CSV file in Oracle Forms 14.1.2, with the columns the user sees in the order they are sorted.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms progress bar at 91 percent while reminders are written
  • Oracle Forms

How to Show a Progress Bar in Oracle Forms

Show users how far a long task has come in Oracle Forms 14.1.2 with the new Progress Bar display item, kept moving with SYNCHRONIZE.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms doctors form showing an inactive doctor with Active unchecked and Show inactive doctors checked
  • Oracle Forms

How to Implement a Soft Delete in Oracle Forms

Keep rows that other tables refer to in Oracle Forms 14.1.2 by turning Delete Record into an update of an active flag with ON-DELETE.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms visit form with three prescription lines copied from the previous visit
  • Oracle Forms

How to Copy Records from the Database into a Block in Oracle Forms

Repeat last time's detail lines in Oracle Forms 14.1.2 by copying them from the database into a block as new records the user checks and saves.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms alert asking to cancel 4 appointments with four rows checked in the block
  • Oracle Forms

How to Process Selected Rows with Check Boxes in Oracle Forms

Let users tick rows and act on all of them at once in Oracle Forms 14.1.2, with a running count, Select All, and a single commit.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms message refusing an appointment that overlaps another of the same doctor
  • Oracle Forms

How to Prevent Overlapping Records Before Saving in Oracle Forms

Refuse records whose time ranges overlap in Oracle Forms 14.1.2, whether the other record is in the database or in the same save.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms refusing to save a cancelled appointment with no reason, showing FRM-40202
  • Oracle Forms

How to Make an Item Required Only in Some Records in Oracle Forms

Require a field only when another field calls for it in Oracle Forms 14.1.2, one record at a time, and let Forms' own validation enforce it.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms LOV listing only the cardiologists after the Cardiology department is chosen
  • Oracle Forms

How to Create Dependent Lists in Oracle Forms

Make one list follow another in Oracle Forms 14.1.2 with an LOV that reads the first item, and learn why a second poplist fails in multi-record blocks.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms search panel listing the patients of Pune sorted by birth date
  • Oracle Forms

How to Build a Search Panel in Oracle Forms

Let users find records by any mix of criteria in Oracle Forms 14.1.2, with a WHERE clause built from bind variables instead of typed values.

  • Vinish Kapoor
  • September 28, 2026
How to Use the Oracle Forms Java API
  • Oracle Forms

How to Use the Oracle Forms Java API

Inventory, change, and build Oracle Forms 14.1.2 modules from Java with JDAPI, and add what Forms Builder would have added for you.

  • Vinish Kapoor
  • September 28, 2026
How to Automate Oracle Forms Builds from the Command Line
  • Oracle Forms

How to Automate Oracle Forms Builds from the Command Line

Compile a whole Oracle Forms 14.1.2 application in the right order from a script, and keep forms as XML to see every change.

  • Vinish Kapoor
  • September 28, 2026
How to Upgrade Oracle Forms Applications to 14.1.2
  • Oracle Forms

How to Upgrade Oracle Forms Applications to 14.1.2

Move Oracle Forms applications from older releases to 14.1.2: what changed, the upgrade steps, the Migration Assistant, and RP2RRO.

  • Vinish Kapoor
  • September 28, 2026
Prev1 … 34 35 36 37 38 39 40 … 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