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
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
How to Secure Oracle Forms Applications
  • Oracle Forms

How to Secure Oracle Forms Applications

Identify users, keep secrets on the server, and close the common holes of an Oracle Forms 14.1.2 installation, with a security checklist.

  • Vinish Kapoor
  • September 28, 2026
How to Trace a Session with Forms Trace in Oracle Forms
  • Oracle Forms

How to Trace a Session with Forms Trace in Oracle Forms

Record user actions, triggers, built-ins, and SQL of an Oracle Forms 14.1.2 session with Forms Trace, and read the trace with Xlate.

  • Vinish Kapoor
  • September 28, 2026
How to Manage an Oracle Forms Production Domain
  • Oracle Forms

How to Manage an Oracle Forms Production Domain

The full Oracle Forms 14.1.2 domain in production: its servers, the start order, maintenance without cutting users off, and the logs.

  • Vinish Kapoor
  • September 28, 2026
How to Set the Oracle Forms Runtime Environment with default.env
  • Oracle Forms

How to Set the Oracle Forms Runtime Environment with default.env

The environment of the Oracle Forms 14.1.2 runtime process: default.env variables, several environment files, and every other config file.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms architecture: Forms client, Forms servlet, Listener servlet, frmweb runtime process, and database
  • Oracle Forms

How to Configure formsweb.cfg in Oracle Forms 14.1.2

How an Oracle Forms 14.1.2 application reaches its users, and how formsweb.cfg sections, URL rules, and parameters control it.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms form with eight items and a clock used to count Forms server requests
  • Oracle Forms

How to Reduce Round Trips to the Forms Server

What each user action sends to the Oracle Forms 14.1.2 server, why a clock is expensive, and how to start faster and serve more users.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms form measuring 4,149 round trips for three POST-QUERY lookups
  • Oracle Forms

How to Reduce Database Round Trips in Oracle Forms

Real measurements from Oracle Forms 14.1.2: what POST-QUERY lookups cost, and how array sizes cut 4,149 database round trips to 19.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms form after running a report with RUN_REPORT_OBJECT, showing the job and URL
  • Oracle Forms

How to Run Oracle Reports from a Form Using RUN_REPORT_OBJECT

Report objects, RUN_REPORT_OBJECT, job status, output, and security: running Oracle Reports 14.1.2 from an Oracle Forms 14.1.2 form.

  • Vinish Kapoor
  • September 28, 2026
Oracle Reports PDF output of a weekly appointment schedule grouped by doctor
  • Oracle Forms

How to Create a Report with Oracle Reports 14.1.2

Oracle Reports 14.1.2 for Forms applications: the domain it needs, the Report Wizard, reports as XML, rwrun, rwservlet, and PDF fonts.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms REST Package Designer showing the operations of a claims service
  • Oracle Forms

How to Generate REST Packages Using the REST Package Designer in Oracle Forms

Turn an OpenAPI document into PL/SQL with the REST Package Designer of Oracle Forms 14.1.2, then call the generated packages from a form.

  • Vinish Kapoor
  • September 28, 2026
Oracle Forms form showing insurance coverage, a submitted claim, and claims from a REST service
  • Oracle Forms

How to Call REST Services from Oracle Forms

GET and POST JSON from Oracle Forms 14.1.2 with the new FHTTP and FJSON packages, with status codes, errors, and credentials.

  • Vinish Kapoor
  • September 28, 2026
Web page chart drawn from data sent by an Oracle Forms form over WebSocket
  • Oracle Forms

How to Connect a Form to a Web Page Using JavaScript in Oracle Forms

WebSocket JavaScript integration in Oracle Forms 14.1.2: run JavaScript in a web page from a form, and raise form events from the page.

  • Vinish Kapoor
  • September 28, 2026
Java bean bar chart in an Oracle Forms bean area with a doctor's appointments listed below
  • Oracle Forms

How to Add Java Beans to Oracle Forms

Java beans in bean areas, pluggable Java components, and FBEAN in Oracle Forms 14.1.2, with properties, events, and JAR deployment.

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