set linesize 200

set pagesize 40

column application_id format 999999999999999

column application_name format a60

column version format a12

column owner format a15

SELECT application_id, workspace, application_name, owner, version

FROM apex_applications 

WHERE workspace != 'INTERNAL'

AND availability_status !='Unavailable'

ORDER BY application_id; 

set linesize 200

set pagesize 40

column application_id format 999999999999999

column application_name format a60

column version format a12

column owner format a15

column availability_status format a30

column workspace format a30

SELECT application_id, workspace, application_name, owner, version, availability_status

FROM apex_applications

WHERE workspace != 'INTERNAL'

ORDER BY application_id;