What are record groups ? Can record groups created at run-time?
ORACLE Interview Questions and Answers (Part 4)
(Continued from previous question...)
646. What are record groups ? Can record groups created at run-time?
A record group is an internal Oracle Forms data structure that has a column/row framework similar to a
database table. However, unlike database tables, record groups are separate objects that belong to the
form module in which they are defined. 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.
Record group column names cannot exceed 30 characters.
Programmatically, record groups can be used whenever the functionality offered by a two-dimensional
array of multiple data types is desirable.
TYPES OF RECORD GROUP:
Query Record Group A query record group is a record group that has an associated SELECT statement.
The columns in a query record group derive their default names, data types, and lengths from the database columns referenced in the SELECT statement. The records in a query record group are the rows retrieved by the query associated with that record group.
Non-query Record Group A non-query record group is a group that does not have an associated query, but whose structure and values can be modified programmatically at runtime.
Static Record Group A static record group is not associated with a query; rather, you define its
structure and row values at design time, and they remain fixed at runtime.
(Continued on next question...)
Other Interview Questions