Oracle APEX Cookbook PDF
Preview Oracle APEX Cookbook
Table of Contents Oracle APEX Cookbook Second Edition 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 Instant Updates on New Packt Books Preface What this book covers What you need for this book Who this book is for Conventions Reader feedback Customer support Downloading the example code 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... Controlling 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 How to do it... How it works... There's more... 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... Creating a data upload page Getting ready How to do it... Using shipped files 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... 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... See also Creating an authorization 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 Web Services Introduction Creating a SOAP web service reference Getting ready How to do it... How it works... See also Creating a REST web service reference Getting ready How to do it... How it works… There's more… Building a page on a web service reference Getting ready How to do it… How it works… There's more… Publishing a RESTful web service Getting ready How to do it… There's more… See also 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...
Description:The list of books you might like
