How to Find LOV Query in Oracle Forms?

How to Find LOV Query in Oracle Forms?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

In Oracle Forms, LOV is used to display List of Values at runtime. There are two types of LOV in Oracle Forms Static and Record Group. Record Group contains the SQL query or the static values. This tutorial explains how to find LOV Query in Oracle Forms.

Follow These Steps to Find LOV Query in Oracle Forms

  1. In the Object Navigator, under LOV node, select the LOV for which you want to find the query and right click on it.
  2. On the shortcut menu, click on the Property Palette.
  3. In the Property Palette window under the functional node, locate the Record Group property.
  4. There you will find the Record Group name. Then close the Property Palette.
  5. In the Object Navigator under Record Group node, select the Record Group name which you just found.
  6. Right click on it and click on the Property Palette.
  7. In the Property Palette window under the functional node, you will find the Record Group Query property, which contains the query.

See also:

  • Display LOV in Oracle Forms
  • Create Dynamic LOV in Oracle Forms