Experiencing Oracle APEX

 Please check out the documentation on the link below: https://apex.oracle.com/pls/apex/f?p=100471:6:6084788408040::::: Hope it helps someone.

I'm pleased to share my first Oracle APEX plugin, It enables users to save files direct to Google drive. Kindly download:  https://api.github.com/repos/KehindeAdeyemi-apex/Save-files-to-Google-Drive/zipball/v1.0 . I hope you find it useful

Below are simple steps to select/unselect all checkboxes in a classic report: 1. Create a page with a classic report based on a sample query      select apex_item.checkbox(1, EMPLOYEE_ID) selectemp,        EMPLOYEE_ID,        FIRST_NAME,        LAST_NAME,        EMAIL,        PHONE_NUMBER,        HIRE_DATE   from EMPLOYEES 2. Add static ID : emp on the classic report region 3. Add below Javascript on the page function handleClick(cb) {     if  (cb.checked === true) {   $('#emp input[type=checkbox][name=f01]').prop('checked',true);       } else {   $('#emp input[type=checkbox][name=f01]').prop('checked',false); } } 4. Change the heading on the SELECTEMP column of the report to below              5. Ensure you set 'Escape Spe...

I like to share my approach on capturing additional information if all attribute columns (flexfields) on a table have been used up. This implementation does not require altering any existing table(s) instead it gives administrators and/or superusers the ability to dynamically manage additional information capture within the application. Below are steps taken: Create tables FLEXFIELD_REGISTRY (This stores the flexfields setup data) and FLEXFIELD_VALUES (This stores the values captured on flexfields)          FLEXFIELD_REGISTRY          FLEXFIELD_VALUES                 2. Create an interactive grid to manage flexfield setups       3. Create additional information form       Application Demo Link:  Flexfield Feature Demo Credentials: demo/demo1234$

Some Oracle APEX customers prefer to view embedded PDF documents directly within a page in their application rather than having to download. My current case study allows users to upload a .pdf document, save directly to a file location (rather than a DB Column) and view same embedded on the current page as shown above. Steps taken: 1. Identify the physical location of the #IMAGE_PREFIX# (/i/), in my case it is/u01/userhome/oracle/apex/images 2. Create a folder called 'docs' in the directory logged in as user SYS $ cd /u01/userhome/oracle/apex/images $ mkdir docs 3. Create a database directory called MY_DOCS create or replace directory MY_DOCS as '/u01/userhome/oracle/apex/images/docs'; Directory MY_DOCS created. grant read,write on directory MY_DOCS to {WORKSPACE_SCHEMA}; Grant succeeded. 4. Create a page within your application with following create page items PXX_FIRST_NAME (Textfield), PXX_LAST_NAME (Textfield), PXX_UPLOAD_DOC (File Browse), PXX...

Hello Peeps, Its been a while i posted on this blog. I have been so taken up with developing an HR and Payroll solution called KODAHR using this wonderful dev tool Oracle APEX 4.1 of course!. Here is a little pic of my brochure. It has delightful features. Feel free to contact me.

I had an urgent need to move loads of APEX workspaces and schemas in an Oracle XE installation from  a Windows PC(PC1) to another Windows PC(PC2) running windows 7 OS. Stated below are the steps i took after a successfully installation of Apex 4.0 on Oracle 10g XE on PC2 Stop listener and other processes on PC2 Rename the oraclexe home folder on PC2 Copy oraclexe home folder from PC1 to PC2 ensure you maintain existing path Ensure your new tnsnames.ora and listener.ora files contains PC2's host name Restart your listener and other processes Though this might not be best practice but it sure worked for me. Hope you find it helpful