Skip to content
Ontoor blogs
  • Videos
    • APEX hours
    • Ontoor Concepts
    • Ontoor Shorts
    • Ontoor Extras
  • Links
    • APEX Tutorials
    • Ontoor Plugins
    • Web Tutorials
    • Events and Webinars
  • Categories
    • APEX
      • APEXOracle APEX RELATED posts
      • APEX Tutorials
      • APEX Plugins
      • Interactive Grid
    • Oracle
      • ORACLE
      • SQL
      • PLSQL
    • Shorts
    • JavaScript
Setup Meeting

Posts by Vikas Pandey

Home » Archives for Vikas Pandey » Page 3
About Vikas Pandey
I am an Oracle APEX Architect and Senior Consultant with 9+ years of hands-on experience in designing, developing, and modernizing enterprise applications using Oracle APEX, Oracle Database, SQL/PLSQL, and ORDS. My professional journey spans pharmaceutical consulting, insurance, healthcare, and enterprise product development, where I have delivered scalable, secure, and performance-optimized solutions for Indian and global clients. Currently, I work as a Senior Consultant at Ernst & Young (EY), focusing on application architecture, data migration, performance tuning, advanced reporting, and system integrations. As an Oracle ACE Associate, I strongly believe in architectural clarity, best practices, and mentoring teams to build long-term sustainable Oracle solutions.
Improve User Experience with Dynamic Column Tooltips in Oracle APEX Interactive Grids
Posted inAPEX Interactive Grid JavaScript

Improve User Experience with Dynamic Column Tooltips in Oracle APEX Interactive Grids

In this article, we'll guide you through adding dynamic tooltips to Interactive Grid (IG) headers in Oracle APEX, utilizing a lookup table for flexibility and customization. This feature improves user…
Posted by Vikas Pandey August 31, 2024
Advanced SQL Query Validation: Ensuring Integrity with PL/SQL
Posted inPLSQL SQL

Advanced SQL Query Validation: Ensuring Integrity with PL/SQL

In today's data-driven world, ensuring the accuracy and integrity of SQL queries is paramount. Invalid queries can lead to errors, performance issues, and data inconsistencies. This blog will deep into…
Posted by Vikas Pandey August 30, 2024
Advanced-Data Processing in Oracle APEX: Interactive Grid to Collection
Posted inAPEX Interactive Grid JavaScript

Advanced-Data Processing in Oracle APEX: Interactive Grid to Collection

This blog will guide you through efficiently managing selected records from an Oracle APEX Interactive Grid. We’ll focus on capturing these selected records and inserting them into APEX collections. APEX…
Posted by Vikas Pandey August 24, 2024
Retrieving Values on Row Click in Oracle APEX Interactive Reports
Posted inAPEX Interactive Report JavaScript

Retrieving Values on Row Click in Oracle APEX Interactive Reports

Interactive reports serve as pivotal components in Oracle Application Express (APEX), offering users a dynamic platform to explore and interact with data. Implementing row click functionality allows users to extract…
Posted by Vikas Pandey May 11, 2024
Auto-Increment Line Numbers in Oracle APEX Interactive Grid on Add Row
Posted inAPEX IG Interactive Grid

Auto-Increment Line Numbers in Oracle APEX Interactive Grid on Add Row

Oracle APEX Interactive Grids offer a powerful and flexible way to interact with data. A common requirement is to have auto-incrementing line numbers for each row, particularly when adding new…
Posted by Vikas Pandey May 4, 2024
Posted inAPEX IG Interactive Grid

Oracle APEX: Setting a Search Field in Interactive Grid from a Previous Page

Oracle APEX allows you to create interactive applications with powerful functionality. A common requirement is to set a search field in an Interactive Grid based on a value from a…
Posted by Vikas Pandey May 4, 2024
Posted inAPEX IG Interactive Grid

Oracle APEX: Navigating to a Specific Column in Interactive Grid After Adding a New Row

Oracle APEX Interactive Grids allow users to manipulate and interact with data efficiently. A common requirement is to automatically navigate to a specific column when a new row is added.…
Posted by Vikas Pandey May 4, 2024
Posted inAPEX CSS Interactive Grid

Restricting Oracle APEX Interactive Grid Columns to Numeric-Only Input with CSS Classes and jQuery

In Oracle APEX applications, it's often necessary to restrict user input to numeric values, especially in Interactive Grids or other data-entry fields. This article demonstrates how to enforce numeric-only input…
Posted by Vikas Pandey May 4, 2024
Retrieving Selected Values from the Current Row in Oracle APEX Interactive Grids
Posted inAPEX IG Interactive Grid

Retrieving Selected Values from the Current Row in Oracle APEX Interactive Grids

Oracle APEX Interactive Grids are powerful tools for managing and interacting with data. A common use case is retrieving a specific value from the current row when a user selects…
Posted by Vikas Pandey April 28, 2024
Horizontal Scrollbar On Top of Interactive Grid Oracle APEX
Posted inAPEX IG Interactive Grid

Horizontal Scrollbar On Top of Interactive Grid Oracle APEX

When working with Oracle APEX Interactive Grids, horizontal scrolling can be crucial for navigating wide datasets. While these grids typically have a horizontal scrollbar at the bottom, adding one to…
Posted by Vikas Pandey April 27, 2024

Posts pagination

Previous page 1 2 3 4 5 … 11 Next page
  • OCI
  • Forms to APEX
  • Reporting
  • 2026 14
  • 2025 12
  • 2024 33
  • 2023 22
  • 2022 26
  • 2021 54
  • 2020 123
  • 2017 12
  • 2016 5
  • 2015 1
Recent Posts
  • Oracle APEX: Generate Realistic Test Data Faster with APEX_DG_DATA_GEN
  • APEX Region Printer Plugin: How to Print Any Oracle APEX Region Cleanly
  • Oracle APEX – CSS + Template Directive Pattern Library
  • Generating QR Codes and Barcodes in Oracle APEX Using APEX_BARCODE
  • Designing a Robust Fusion-to-ATP Data Sync Framework for Oracle APEX
Categories
  • APEX 232
  • APEX Hours 3
  • APEX Tutorials 18
  • APEX_AUTOMATION 4
  • APEX_DG_DATA_GEN 1
  • APEX_JSON 2
  • APEX_WEB_SERVICE 2
  • API 1
  • CSS 1
  • DBA 3
  • Deprecated 1
  • Events and Webinars 8
  • Fusion 1
  • GITHUB 3
  • IG 23
  • Interactive Grid 39
  • Interactive Report 1
  • JavaScript 21
  • JS_API 2
  • OCI 4
  • Ontoor Concepts 5
  • Ontoor Extras 1
  • ORACLE 44
  • Oracle 23 ai 1
  • Oracle Tutorials 1
  • ORACLE_FORMS 1
  • ORDS 4
  • Others 4
  • PLSQL 13
  • PLUGINS 13
  • PostgreS 1
  • Reporting 1
  • Shorts 9
  • SQL 18 
Copyright © 2026 Ontoor Solutions. All Rights Reserved.
Copyright 2026 — Ontoor blogs. All rights reserved. Bloghash WordPress Theme
Scroll to Top