APEX: Reset default workspace password
Here is how to reset default workspace (INTERNAL) password:Run sqlplus, but from the directory, in which you have the apex sql scripts and execute the following:conn / as sysdba@apxchpwdSet the…
Oracle Application Express
Oracle DB: Install APEX 4.2
Here is how to install APEX 4.2 on Oracle 11g:Download Apex 4.0.2:http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.htmlin C:\apps\ApexDownload Apex Listener:http://www.oracle.com/technetwork/developer-tools/apex-listener/downloads/index.htmlin C:\apps\Apex_ListenerMake a shortcut to SQL Plus 11:C:\Oracle\product\11.2.0\dbhome_1\BIN\sqlplus.exe /nolognamed: Apex SQL Plus 11 wirh working directory…
APEX: Use CheckBoxes in APEX Report
Sometimes it is necessary to have a checkbox in the first row, in order to do something with the records (delete, update). In this case we can use the following…
APEX: Open as Excel
A PL/SQL package can create an excel output, using the following technique:In your package APPS.XXMY_PKG, procedure HTML_OUTPUT: if n_is_excel = 1 then --Set headers to create excel OWA_UTIL.MIME_HEADER('application/ms-excel;', FALSE); HTP.P('content-disposition:…