Types of Record Groups:

There are three of record groups: static record groups, query record groups, and non-query groups.

Query Record: A  query  record  group is a record  group  in which  Group  has  an  related SELECT statement. A column in a query record group derives their default names,   lengths and data types from the database columns referenced in the SELECT statement.

Non-query: A non-query record group is a group in which Record Group doesn't has a related query, but that structure and values can be modified programmatically at runtime.

Static Record: A static record group is not related with a Group query; otherwise, you define its row values and structure at design time and they remain fixed at runtime.

A record group can have an unlimited number of columns of type char, number, long or date. Whenever you a create an LOV, we can specify that of the columns in the underlying records should be shown in the LOV window. They will be displayed in the order in which they occur in the record group. Since LOV's and record groups are divided objects, we can create multiple LOV's based on the similar record group.

Record Group Valued:

The fact values in a record group come from one of two sources that are:

• The execution of a SELECT statement in which you associated with the record group at design time (query record group) an array of static values which you associated with the record group at design time (static record group).