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.
c002 last_name, c003 first_name,
c004 rsvp_date, c005 company, c006 mod
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:
Oracle Application Express
Dynamic Web Pages with OAE
Michael Cunningham & Kent Crotty