Oracle Tips by Burleson
Select Lists can exist in a region as a selectable
page item or can be used in a tabular form region.
To create a Select List in a region click on the icon
in the Items region on the Page Definition page:
On the Item Type page, select the type of list from table 10.2
to create and click Next.
On the Display Position and Name page.
Item Name: Enter the name of the item.
Sequence: Enter the sequence based on
where the page item is to be displayed in the region.
Region: Select the region in which this
page item should be displayed.
On the Identify List of Values page:
Answering YES here
will cause the select list to be rendered with an extra item
indicating null. The default text that will be displayed in the
select list to indicate null is %.
Null Text: Enter the text to be
displayed in the event the session state for the select list is
NULL. In Figure 10.22, the text – Select Payment – will be
displayed in the select list when a value has not been selected
from the list.
Null Value: Enter a value to be used in
session state if no item is selected in the select list. This
item can be used in page validations to check if an item has been
selected. It is common to use a -1 for numeric data and an X for
On the Item Attributes page:
Label: Enter the text to display next
to the select list.
Label Alignment: Choose the position to
place the label.
Field Width: This is not used for
Field Alignment: Select the position to
display the select list in relation to the table cell in which it
will be rendered.
Label Template: Choose the template to
be used for the label.
On the Source page:
Item Source: Choose the source for
where the value is being set from. It is normal to leave this set
to Static Assignment where the value equals source attribute.
What that means is when the page is rendered, the selected item
will be set to the value corresponding with the session state for
the page item.
Default: Enter the value that the
select list will default to. If NULL is displayed, this should be
the same as the Null Value explained above.
Click the Create Item button to not set
any conditions, or click Next to set conditions.
On the Cachingpage, select
the desired Derive Item Source
option. The default is Only when the value is NULL.
Click the Create Item button.
The above book excerpt is from:
Oracle Application Express
Dynamic Web Pages with OAE
Michael Cunningham & Kent Crotty