set echo off
set verify off
set feedback off
set heading off
set trimspool on
set termout off
set pagesize 0

spool &1

select to_char(workspace_id)
from apex_workspaces
where source_identifier is null;

spool off
exit

Add SQL script to output workspace IDs Looks like internal workspaces don't have the source_identifier set. Previously was using the condition:
Add SQL script to output workspace IDs
Looks like internal workspaces don't have the source_identifier set.
Previously was using the condition:

where workspace not in ('INTERNAL', 'COM.ORACLE.APEX.REPOSITORY');

However, looking at apex 4 to 5, it looks like this list changes.
