Execute a Query for a Banner Object

You can execute a Query for a Banner Object. Make sure that you have chosen the appropriate object type from the Object Type drop-down menu and that your cursor is in the left pane of the Maintenance form.

Select Enter from the Query drop-down menu, or use the <Enter Query> function. This will display a blank two-column list in the left pane — including an Object Name and a Description column. — but there is no visual marker to dividing them. Enter the object name or description that you are searching for into a blank field. Note that this search is case-sensitive; the first letter of each word in a description is usually capitalized, but there are exceptions. Use the % and _ wildcards as needed.

 

Execute a Query for a Form in the Name field

Make sure Oracle Form object is the value in the Object Type field.

If your cursor is not already in the left pane, use <Next Block> to move there.

Select Enter from the Query drop-down menu, or use the <Enter Query> function.

The known characters from the object name are SH. So use the % wildcard and enter SH% into the Object name field.

Select Execute from the Query drop-down menu, or use the <Execute Query> function. All forms with names beginning with SH appear in the list. Select the desired form by double-clicking in the name or description field, and then click the Insert button (  ) to insert it into My Banner.

Execute a Query in the Description field

Make sure Oracle Form object is the value in the Object Type field.

 

If your cursor is not already in the left pane, use <Next Block> to move there.

Select Enter from the Query drop-down menu, or use the <Enter Query> function.

 

The known characters from the description are Trans. Use the % wildcard and enter %Trans% into the Description field.

Select Execute from the Query drop-down menu, or use the <Execute Query> function. All forms that include the characters “Trans” as part of the description appear in the list. Select the desired form by double-clicking in the name or description field, and then click the Insert button (  ) to insert it into My Banner.