Sometimes, you just want to be able to search your APEX exports for source code or compare. Just like we do with ALL_SOURCE (or USER_SOURCE).

Here is some code to export your APEX Application straight into a table so you can query the source code.

/*
CREATE TABLE A_APEX_EXPORT
   (	"EXP_TEXT" VARCHAR2(4000 BYTE), 
	"POS" NUMBER, 
	"APP_ID" NUMBER
   ) 
*/
declare
  cursor c_apps is
    select application_id
         , workspace
      from apex_applications
     where application_id = :app_id
     order by application_id;
    
    l_export_clob  CLOB; 
    l_buffer       VARCHAR2(32767);
    l_amount       BINARY_INTEGER;
    l_pos          INTEGER := 1;
    l_lng          INTEGER;
begin
    apex_custom_auth.set_user('ADMIN'); 
    for i in c_apps loop      
    wwv_flow_api.set_security_group_id(apex_util.find_security_group_id(i.workspace));
     l_export_clob := wwv_flow_utilities.export_application_to_clob (i.application_id);
     
     l_lng := dbms_lob.getlength(l_export_clob);
     
     loop
        l_amount :=  dbms_lob.instr(l_export_clob,chr(10),l_pos,1) - (l_pos + 1);        
        dbms_lob.read (l_export_clob, l_amount, l_pos, l_buffer);         
        insert into a_apex_export values (l_buffer,l_pos,i.application_id);
    
        if l_lng < l_amount + l_pos then 
          exit;
        else 
          l_pos := l_pos + l_amount;
        end if;        
    end loop;

  end loop;

end;
/

/* 
select *
  from a_apex_export
order by pos;
*/

Related Posts