Skip to Main Content

Report Map

PL/SQL Function returning SQL Query

The map region has Source Type set to PL/SQL Function returning SQL Query, with the source set to:
return q'~
select c003 as lat, c004 as lng, c002 as name, c001 as id, c002 || ' (id=' || c001 || ')' as info
from apex_collections
where collection_name = 'MAP'
~';