Working With Record Groups:

A  record  group  is  an  internal  Oracle  Forms  data  structure  which  has  a  column or  row framework same to a database table. Thus, unlike database tables, record groups are divide objects which belong to the form module in that they are defined.

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

A  record  group  established  from  a  query  can  store  records  from  database  tables  much  such as  a database view, with the added advantage in which the record group is local to Oracle Forms, rather than existing in the database.