 |
|
ss
Oracle Tips by Burleson |
Displaying Data from a Collection in a Report
Again on page 1132 there is a report that is
populated with the following query. This is an example of being able
to query the members from the htmldb_collections view. The query is
using aliases to make it easier to know what each column is doing.
This is not necessary, but if looking at this code six months after it
was originally written, it would be easier figuring out what is what.
select seq_id,
c002 last_name, c003 first_name,
c004 rsvp_date, c005 company, c006 mod
from htmldb_collections
where collection_name = 'CONF'
and c006 <> 'D'
There is more information about the collections
API in the HTML DB documentation.
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
|
