Oracle APEX 4.0 Cookbook -- Table of Contents -- Oracle APEX 4.0 Cookbook -- Credits -- About the Authors -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Errata -- Piracy -- Questions -- 1. Creating a Basic APEX Application -- Introduction -- Creating an APEX 4.0 application -- How to do it... -- How it works... -- Creating a simple form page -- Getting ready -- How to do it... -- How it works... -- There's more… -- Creating a simple report -- Getting ready -- How to do it... -- How it works... -- See also -- Implementing an interactive report -- Getting ready -- How to do it... -- There's more... -- Creating a chart -- Getting ready -- How to do it... -- There's more... -- Creating a map chart -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a navigation bar -- Getting ready -- How to do it... -- There's more... -- See also -- Creating a list of values -- Getting ready -- How to do it... -- How it works... -- There's more... -- Including different item types -- Getting ready -- How to do it... -- Protecting a page using an authorization scheme -- Getting ready -- How to do it... -- How it works... -- There's more... -- Securing an application with Authentication -- Getting ready -- How to do it... -- Control the display of regions and items with Dynamic Actions -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a computation -- How to do it... -- There's more... -- Creating an automated row fetch with a page process -- Getting ready -- How to do it... -- How it works... -- Putting some validation in a form -- Getting ready.

How to do it... -- How it works... -- There's more... -- See also -- Creating a report with PL/SQL Dynamic Content -- How to do it... -- 2. Themes and Templates -- Introduction -- Creating your own theme -- Getting ready -- How to do it... -- How it works... -- Importing a theme -- Getting ready -- How to do it... -- How it works... -- Creating a custom template -- Getting ready -- How to do it... -- There's more... -- Including images in your application -- Getting ready -- How to do it... -- How it works... -- There's more... -- Referencing CSS classes in your application -- Getting ready -- How to do it... -- How it works... -- Controlling the layout -- Getting ready -- How to do it... -- How it works... -- There's more... -- 3. Extending APEX -- Introduction -- Adding JavaScript code to your application -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a tag cloud with AJAX -- Getting ready -- How to do it... -- How it works... -- Creating visual effects with JavaScript libraries -- Getting ready -- How to do it... -- How it works... -- There's more -- Enhancing your application with the Google API -- Getting ready -- How to do it... -- How it works... -- See also -- Including Google maps -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Embedding multimedia objects in your application -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also… -- Creating a region selector -- Getting ready -- How to do it... -- How it works... -- Sending mail via APEX -- Getting ready -- How to do it... -- How it works... -- Uploading and downloading files -- Getting ready -- How to do it... -- How it works... -- There's more... -- Calling APEX from an Oracle Form -- Getting ready -- How to do it... -- How it works... -- There's more...

4. Creating Websheet Applications -- Introduction -- Creating a websheet application -- Getting ready -- How to do it... -- How it works -- See also -- Creating a page in a websheet -- Getting ready -- How to do it... -- Adding a navigation section to a page -- Getting ready -- How to do it... -- Implementing a datagrid -- Getting ready -- How to do it... -- How it works... -- See also -- Allowing multiple users access to a websheet -- Getting ready -- How to do it... -- How it works... -- Creating an enhanced datagrid from a spreadsheet -- How to do it... -- There's more... -- 5. APEX Plug-ins -- Introduction -- Creating an item type plug-in -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Creating a region type plug-in -- Getting ready -- How to do it... -- How it works... -- See also -- Creating a dynamic action plug-in -- Getting ready -- How to do it... -- How it works... -- Creating a process type plug-in -- Getting ready -- How to do it... -- How it works... -- There's more... -- 6. Creating Multilingual APEX Applications -- Introduction -- Creating a translatable application -- Getting ready -- How to do it... -- See also -- Using XLIFF files -- Getting ready -- How to do it... -- How it works... -- Switching languages -- Getting ready -- How to do it... -- Translating data in an application -- Getting ready -- How to do it -- How it works -- 7. APEX APIs -- Introduction -- Updating a table with the hidden primary key -- Getting ready -- How to do it... -- How it works... -- Reading a checkbox programmatically -- Getting ready -- How to do it... -- Creating help functionality with apex_application.help -- Getting ready -- How to do it... -- How it works... -- There's more... -- Counting clicks with apex_util.count_click -- Getting ready -- How to do it... -- How it works... -- There's more...

Setting default item settings with apex_ui_default_update -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a background process with apex_plsql_job -- Getting ready -- How to do it... -- How it works... -- There's more... -- 8. Using Webservices -- Introduction -- Creating a SOAP webservice reference -- Getting ready -- How to do it... -- How it works… -- See also -- Creating a REST webservice reference -- Getting ready -- How to do it... -- How it works… -- There's more... -- Building a page on a webservice reference -- Getting ready -- How to do it... -- How it works… -- There's more… -- 9. Publishing from APEX -- Introduction -- Exporting to a comma separated file -- Getting ready -- How to do it... -- How it works... -- Creating a PDF report -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a report query -- Getting ready -- How to do it... -- How it works... -- Creating a report layout using Oracle BI Publisher -- Getting ready -- How to do it... -- How it works... -- Linking the report layout to the report query -- Getting ready -- How to do it... -- How it works... -- Calling a report from a page -- Getting ready -- How to do it... -- How it works... -- 10. APEX Environment -- Introduction -- Setting up a development environment using subscriptions -- How to do it... -- Debugging an APEX application -- Getting ready -- How to do it... -- There's more... -- Debugging an APEX application remotely -- Getting ready -- How to do it... -- How it works -- Deploying an application with SQL Developer -- Getting ready -- How to do it... -- Setting up version control with APEX and SVN -- Getting ready -- How to do it... -- Setting up a production environment using an Apache proxy -- Getting ready -- How to do it... -- Setting up the APEX Listener on Weblogic -- Getting ready.

How to do it... -- 11. APEX Administration -- Introduction -- Creating a workspace manually -- Getting ready -- How to do it... -- How it works -- Creating a workspace by request -- Getting ready -- How to do it... -- There's more... -- Creating a user -- Getting ready -- How to do it... -- Adding a schema to your workspace -- Getting ready -- How to do it... -- How it works -- Setting a system message -- Getting ready... -- How to do it... -- There's more... -- Setting a workspace announcement -- Getting ready -- How to do it... -- There's more... -- Setting news items on the home page -- Getting ready -- How to do it... -- There's more... -- Creating a site-specific task list -- Getting ready... -- How to do it... -- How it works… -- There's more... -- Creating a public theme -- Getting ready... -- How to do it... -- How it works... -- There's more... -- Locking a workspace -- Getting ready... -- How to do it... -- How it works... -- There's more... -- 12. Team Development -- Introduction -- Creating a list of features -- Getting ready -- How to do it... -- There's more... -- Creating and assigning To-do's -- Getting ready -- How to do it... -- Keeping track of bugs in the Bugtracker -- Getting ready -- How to do it... -- There's more… -- Creating Milestones -- Getting ready -- How to do it... -- Using Feedback -- Getting ready -- How to do it... -- There's more... -- Using Follow-ups -- Getting ready -- How to do it… -- How it works -- Index.