Experiencing Oracle APEX

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