clob2file.sql

script
// issue the sql
var binds = {}
var  ret = util.executeReturnList('select help_text,page_name from APEX_APPLICATION_PAGES where rownum=1 and help_text is not null',binds);

// loop the results
for (i = 0; i < ret.length; i++) {
   // debug is nice
    ctx.write(  ret[i].PATH+ "\n");
   // get the CLOB stream


   // get the path/file handle to write to
     var path = java.nio.file.FileSystems.getDefault().getPath(ret[i].PAGE_NAME + "_help.txt");

   // dump the file stream to the file
     java.nio.file.Files.copy(  ret[i].HELP_TEXT.getAsciiStream(),path);
     blobStream.close();
}
/
!ls *help.txt