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

Creating a Query Record Group at Design Time

To create a query record group at design time:

  1. In the Object Navigator, click the Record Groups node.
  2. Click Create in the toolbar.
  3. In the New Record Group dialog, click Based on the Query Below and then enter a SELECT statement in the Query Text field. The WHERE clause for the SELECT statement can include references to global variables and form parameters.
  4. Click OK.
    Oracle Forms validates the SELECT statement and dismisses the dialog.

    Note: The new record group does not yet have any rows. The rows are returned at runtime by the query associated with the group:


About record group Built-in subprograms

About manipulating a record group at runtime

Modifying an existing record group

Performing operations on rows

Viewing the structure of your record group

Modifying the SELECT statement for your query record group