Joining Oracle ApEx Collections to Actual Tables
Hoping someone can help but within Oracle ApEx is it possible to join an actual table in your schema to an Oracle ApEx Collection, as I am having trouble doing so?
Basically have the following scenario:
select c001, -- employee id from collection
c002,
c003 -- employee dept no from collection
from apex_collections,
emp
where collection = 'MY_COOLECTION'
and emp.id = c001
and emp.deptno = c003;
Is the above possible or am I missing something?
Thanks.
Edited by: Tony F. on Jul 18, 2011 1:05 AM