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 form counting the rows of PRESCRIPTIONS with EXEC_SQL
  • Oracle Forms

How to Run Dynamic SQL in Oracle Forms Using FORMS_DDL

Oracle Forms 14.1.2 has no EXECUTE IMMEDIATE. Here is how FORMS_DDL and EXEC_SQL run dynamic statements and queries safely.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms PL/SQL Editor refusing an ANSI join with PLS-103
  • Oracle Forms

How to Write PL/SQL in Oracle Forms

Where PL/SQL lives in Oracle Forms 14.1.2, how it refers to the form, what the Forms engine rejects, and how stored code fills the gaps.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms visits form started for patient 10125 by a parameter in the URL
  • Oracle Forms

How to Pass Parameters to a Form in Oracle Forms

Form parameters in Oracle Forms 14.1.2: declaring them, using them in code and WHERE clauses, and passing them through otherparams and formsweb.cfg.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms custom editor ED_NOTES showing long visit notes wrapped by word
  • Oracle Forms

How to Use Editors in Oracle Forms

Editors in Oracle Forms 14.1.2: the default editor, custom editors with their own size and wrapping, and opening an editor from code.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms caution alert asking whether to clear the notes
  • Oracle Forms

How to Show Alerts in Oracle Forms Using SHOW_ALERT

Alerts in Oracle Forms 14.1.2: styles and buttons, SHOW_ALERT and the button pressed, and messages built at run time with SET_ALERT_PROPERTY.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms LOV showing a record group of durations built at run time
  • Oracle Forms

How to Create Record Groups at Run Time in Oracle Forms

Query, static, and run-time record groups in Oracle Forms 14.1.2, with a group built in code for an LOV and the built-ins that read it.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms LOV reduced to patient names starting with Sar by Validate from List
  • Oracle Forms

How to Create an LOV in Oracle Forms Using the LOV Wizard

Create lists of values with the LOV Wizard in Oracle Forms 14.1.2: return items, Validate from List, FRM-40502, dependent queries, and built-ins.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms item APPT_START inheriting properties from the property class PC_READONLY
  • Oracle Forms

How to Use Property Classes in Oracle Forms

Property classes in Oracle Forms 14.1.2: creating them, inheriting and overriding properties, sharing them, and the rules of inheritance.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms Layout Editor with three items selected on a canvas
  • Oracle Forms

How to Use the Layout Editor in Oracle Forms

Draw and arrange canvases in the Oracle Forms 14.1.2 Layout Editor: tools, alignment, frames, and design-time and run-time colors.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms schedule with cancelled records in gray, missed in red, and the current record highlighted
  • Oracle Forms

How to Highlight Records Using Visual Attributes in Oracle Forms

Use named visual attributes in Oracle Forms 14.1.2 to highlight the current record, style records by status, and band alternate rows.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms modal dialog window opened by navigating to one of its items
  • Oracle Forms

How to Manage Windows in Oracle Forms

Document and dialog windows in Oracle Forms 14.1.2: opening them by navigation, closing them correctly, window triggers, and built-ins.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms patient file with a toolbar canvas, a content canvas, and a tab canvas
  • Oracle Forms

How to Use Canvases in Oracle Forms

The five canvas types of Oracle Forms 14.1.2, with a form that uses them all, plus WHEN-TAB-PAGE-CHANGED and the SHOW_VIEW built-ins.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms hierarchical tree of medicine categories with a medicine selected
  • Oracle Forms

How to Create a Hierarchical Tree in Oracle Forms Using FTREE

Build a tree of categories and items in Oracle Forms 14.1.2: the five-column CONNECT BY query, node icons, tree triggers, and FTREE built-ins.

  • Vinish Kapoor
  • September 28, 2026
Bar chart of appointments per department built from Oracle Forms display items
  • Oracle Forms

How to Create Charts in Oracle Forms 14.1.2

The chart item is gone in Oracle Forms 14.1.2. Here is what replaces it, with a complete bar chart built from ordinary display items.

  • Vinish Kapoor
  • September 28, 2026
Property Palette of the Oracle Forms push button LOAD_PHOTO with Iconic and Icon Filename
  • Oracle Forms

How to Create Push Buttons in Oracle Forms

Push buttons in Oracle Forms 14.1.2: labels, icons, access keys, buttons that do not take the cursor, and deploying icons in a JAR file.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms image item showing a patient photo loaded with READ_IMAGE_FILE
  • Oracle Forms

How to Display Images in Oracle Forms Using READ_IMAGE_FILE

Image items in Oracle Forms 14.1.2: formats, sizing styles, loading a photo with READ_IMAGE_FILE, and saving it to a BLOB column.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms patient form with a Gender radio group of Female, Male, and Other
  • Oracle Forms

How to Use Radio Groups in Oracle Forms

Radio groups in Oracle Forms 14.1.2: radio buttons and their values, initial values, unmapped values, WHEN-RADIO-CHANGED, and button properties.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms message after unchecking the Active check box
  • Oracle Forms

How to Use Check Boxes in Oracle Forms

Check boxes in Oracle Forms 14.1.2: checked and unchecked values, other values, the WHEN-CHECKBOX-CHANGED trigger, and CHECKBOX_CHECKED.

  • Vinish Kapoor
  • September 28, 2026
Prev1 … 37 38 39 40 41 42 43 … 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