 |
|
ss
Oracle Tips by Burleson |
Lists of
Values
A List of Values (LOV) is a reusable list that can
be built dynamically with a SQL select statement or with a static set
of values typed in by the developer. The two types of LOV’s are
Static and Dynamic.
Static LOV
To create a static LOV, navigate to the Shared
Components page.
1.
On the Shared Components page, click the Lists of Values link.
2.
Click the Create button.
3.
On the Source page, choose the From Scratch option.
4.
On the Name and Type page:
5.
On the Query or Static Values page, enter values for the LOV.
The Display Value can be whatever the developer decides, but the
Return Value should match any referential integrity in the database.
Figure 10.20 shows the values entered for the example.
6.
Finally, click the Create List of Values 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
|