 |
|
ss
Oracle Tips by Burleson |
Dynamic
LOV
The values in a dynamic LOV are populated using a
SQL select statement.
To create a dynamic 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 the query to select
the data from a database table and then click the Create List of
Values button. Our example has the query below.
select distinct payment d, upper(
payment ) r
from conference_rsvp
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
|
