Skip to content
No results
  • Portfolio
  • Blog
  • Oracle 23ai
  • Oracle APEX
  • Oracle Forms
  • PL/SQL
  • SQL
  • Topics
  • Tools
  • About
  • Write Code
  • SQL Formatter
  • APEX Formatter
  • Roadmaps
    • Oracle APEX Roadmap
    • Oracle Database Roadmap
    • Software Engineering Roadmap
    • AI Developer Roadmap
  • Products
    • VinAura - Visual PDF Designer for Oracle APEX
    • Rounds HMS - Hospital ERP
    • SmartShare for WordPress
Simulators & Games
Vinish Kapoor.
  • Portfolio
  • Blog
  • Oracle 23ai
  • Oracle APEX
  • Oracle Forms
  • PL/SQL
  • SQL
  • Topics
  • Tools
Products
  • VinAura PDF Free
    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
  • 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
  • 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
  • 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 Kindle now, paperback soon
Vinish Kapoor.
Simulators & Games
Products
  • VinAura PDF Free
    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
  • 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
  • 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
  • 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 Kindle now, paperback soon
WebUtil file open dialog on the user's computer in Oracle Forms
  • Oracle Forms

How to Work with Client Files Using WebUtil in Oracle Forms

Reach the user's computer from Oracle Forms 14.1.2 with WebUtil: setup, file dialogs, client images and text files, transfers, and security.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms waiting room refreshed by a database change notification event
  • Oracle Forms

How to Handle Events in Oracle Forms

System and database events in Oracle Forms 14.1.2: client idle, and change notifications that refresh a form when another session changes rows.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms one-shot timer navigating to a record after WHEN-VALIDATE-ITEM
  • Oracle Forms

How to Use Timers in Oracle Forms

Timers in Oracle Forms 14.1.2: a clock, what repeating timers cost, and the one-shot timer that runs code a trigger cannot.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms Object Library window with alerts, visual attributes, property classes, and SmartClasses
  • Oracle Forms

How to Reuse Objects with Object Libraries in Oracle Forms

Keep every form of an Oracle Forms 14.1.2 application consistent with an object library: subclassing, SmartClasses, and template forms.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms block on transactional triggers showing a doctor's half-hour slots
  • Oracle Forms

How to Base a Block on Transactional Triggers in Oracle Forms

When rows exist in no table: an Oracle Forms 14.1.2 block on transactional triggers that computes a doctor's slots in ON-SELECT and ON-FETCH.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms FROM clause query block showing Cardiology doctors ranked among all doctors
  • Oracle Forms

How to Base a Block on a FROM Clause Query in Oracle Forms

Show a report with ANSI joins and analytic functions in an Oracle Forms 14.1.2 block, without creating a view, and see the SQL it sends.

  • Vinish Kapoor
  • September 28, 2026
Data Block Wizard query procedure page for a block based on stored procedures
  • Oracle Forms

How to Base a Block on Stored Procedures in Oracle Forms

Route every query and change through a PL/SQL API: an Oracle Forms 14.1.2 block on stored procedures, from the package to its error messages.

  • Vinish Kapoor
  • September 28, 2026
Stepping through a library procedure in the Oracle Forms debugger
  • Oracle Forms

How to Debug Oracle Forms Using the Forms Debugger

Find what goes wrong in Oracle Forms 14.1.2: run a form in the debugger, step through code, inspect variables, and attach to running forms.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms ON-ERROR turning a foreign key error into a clear message
  • Oracle Forms

How to Handle Errors in Oracle Forms Using ON-ERROR

Messages, alerts, and errors in Oracle Forms 14.1.2, and how ON-ERROR turns database errors into messages users understand.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms menu item disabled by database-role menu security
  • Oracle Forms

How to Secure Menus with Roles in Oracle Forms

Application roles and database-role menu security in Oracle Forms 14.1.2: disabling menu items by role, checking roles in forms, and the setup.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms Menu Editor with the Clinic menu open
  • Oracle Forms

How to Create a Menu in Oracle Forms

Replace the default menu in Oracle Forms 14.1.2 with your own menu module, popup menus, and items that change at run time.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms called form showing a value shared through library data
  • Oracle Forms

How to Pass Values Between Forms in Oracle Forms

Parameter lists, global variables, and shared library data in Oracle Forms 14.1.2: how called forms get their input and return a choice.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms appointments form called with NO_HIDE over the patient list
  • Oracle Forms

How to Open Another Form in Oracle Forms

CALL_FORM, OPEN_FORM, and NEW_FORM in Oracle Forms 14.1.2: when to use each, their options, commits across forms, and switching forms.

  • Vinish Kapoor
  • September 28, 2026
The library CW_LIB attached to an Oracle Forms form without a path
  • Oracle Forms

How to Create a PL/SQL Library in Oracle Forms

Share code across Oracle Forms 14.1.2 with a PL/SQL library: create it, attach it without a path, deploy the .plx, and change it safely.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms form listing its session properties from GET_APPLICATION_PROPERTY
  • Oracle Forms

How to Read Application Properties Using GET_APPLICATION_PROPERTY

Every property GET_APPLICATION_PROPERTY returns in Oracle Forms 14.1.2, with a form that lists its own session, and what can be changed.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms block made read-only at run time with a changed prompt and a disabled radio button
  • Oracle Forms

How to Change Items at Run Time Using SET_ITEM_PROPERTY

The FIND_, GET_, SET_ pattern of Oracle Forms 14.1.2, the item properties you change most, and generic code that walks a block.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms retrying a row lock held by another session
  • Oracle Forms

How to Handle Record Locking in Oracle Forms

Record locking in Oracle Forms 14.1.2: Immediate and Delayed modes, locks held by others, rows changed by others, and preventing lost updates.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms fees form with two changed fees and the audit rows written in the same transaction
  • Oracle Forms

How to Save Changes Using Commit Processing in Oracle Forms

What happens when an Oracle Forms 14.1.2 form saves: the commit steps and triggers, audit rows, generated keys, POST, and rollback.

  • Vinish Kapoor
  • September 28, 2026
Prev1 2 3 4 5 6 … 49Next
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