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

Specifying LOV Return Items in the SELECT Statement

To specify a return item in the SELECT statement:

For example, assume you want all of the information about a customer to be returned into the appropriate form items whenever an end user chooses a name from the customer LOV. To do so, you might write the following SELECT statement when you create the record group:

SELECT id, name, contact, phone
INTO :cust.id, :cust.name :cust.contact, :cust.phone
FROM CUSTOMER;

When you create the record group, Oracle Forms parses the SELECT statement and inserts the names of the return items in the Return Item fields for you automatically.

The order of the return items referenced in the INTO clause must correspond to the order of the database columns referenced in the SELECT clause.

Note: The INTO clause establishes the relationship between the LOV and the return items but does not affect the definition of the resulting record group. When you view the new record group in the Property Palette, you see only the SELECT statement without the INTO clause. It is the LOV itself that is associated with the return items, not the record group object.


Specifying LOV return items using column properties