Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

 

   
 

ss

Oracle Tips by Burleson 

Select Lists

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:

1.       On the Item Type page, select the type of list from table 10.2 to create and click Next.

2.       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.

  • Click Next

3.       On the Identify List of Values page:

  • Named LOV: Enter the name of the LOV that will provide the values for this select list.

  • Display Null Option: Choose whether or not to display the fact that the session state for the item is null.

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 character data.

  • Click Next.

4.       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 select lists.

  • 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.

  • Click Next. 

5.       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.

6.       On the Cachingpage, select the desired Derive Item Source option.  The default is Only when the value is NULL.

7.       Click the Create Item button.


The above book excerpt is from:

Easy HTML-DB Oracle Application Express

Create Dynamic Web Pages with OAE

ISBN 0-9761573-1-4   

Michael Cunningham & Kent Crotty

http://www.rampant-books.com/book_2005_2_html_db.htm

 

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

 

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster



Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks