A script-enabled browser is required for this page to function properly.

About LOV Values and Record Groups

LOV values are derived from an internal data structure called a record group. When you define an LOV, you associate it with a named record group.

A record group has a column/row framework that is similar to a database table. The LOV is the interface object that allows end users to view, scroll, and select records currently stored in the underlying record group.

A record group can have an unlimited number of columns of type CHAR, LONG, NUMBER, or DATE, provided that the total number of columns does not exceed 64K.

When you create an LOV, you specify which of the columns in the underlying record group should be displayed in the LOV window. Record group columns are always displayed in the LOV window in the order that they occur in the record group.

Because LOVs and record groups are separate objects, you can create multiple LOVs based on the same record group. For example, you might create two LOVs based on the same 4-column record group, each of which might display different columns from that record group.

Record Group Values

The actual values in a record group come from one of two sources:

Note: By default, when an LOV is based on a query record group (a record group that has an associated SELECT statement), Oracle Forms executes the query each time the LOV is displayed, and fetches all of the records that meet the record group query criteria. This functionality ensures that the LOV always displays current database values.