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

Creating a Query Record Group at Runtime

You can use the CREATE_GROUP_FROM_QUERY function to create query record groups programmatically at runtime. To call this function, you pass in the SELECT statement that you want to associate with the record group. The columns in the resulting group correspond to the database columns referenced in the SELECT statement.

The return value of CREATE_GROUP_FROM_QUERY is the object ID of the new group. Assign this return value to a variable that you declared as type Record Group.

A call to CREATE_GROUP_FROM_QUERY creates a group that does not yet have any rows. To populate the group you must explicitly execute its associated query by calling the function POPULATE_GROUP. The return value of the POPULATE_GROUP function is 0 if the query succeeds or an ORACLE error number if it fails.


About record group Built-in subprograms

About manipulating a record group at runtime

Modifying an existing record group

Performing operations on rows

CREATE_GROUP_FROM_QUERY Built-in

POPULATE_GROUP_WITH_QUERY Built-in

POPULATE_GROUP Built-in