You are previewing Oracle APEX 4.0 Cookbook.
O'Reilly logo
Oracle APEX 4.0 Cookbook

Book Description

Over 80 great recipes to develop and deploy fast, secure, and modern web applications with Oracle Application Express 4.0

  • Create feature-rich web applications in APEX 4.0

  • Integrate third-party applications like Google Maps into APEX by using web services

  • Enhance APEX applications by using stylesheets, Plug-ins, Dynamic Actions, AJAX, JavaScript, BI Publisher, and jQuery

  • Hands-on examples to make the most out of the possibilities that APEX has to offer

  • Part of Packt's Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible

  • In Detail

    Oracle Application Express 4.0 is a rapid web application development tool that works with the Oracle database. Using features like Plug-ins and Dynamic Actions, APEX helps you build applications with the latest techniques in AJAX and JavaScript.

    The Oracle Application Express 4.0 Cookbook shows you recipes to develop and deploy reliable, modern web applications using only a web browser and limited programming experience.

    With recipes covering many different topics, it will show you how to use the many features of APEX 4.0.

    You will learn how to create simple form and report pages and how to enhance the look of your applications by using stylesheets. You will see how you can integrate things such as Tag Clouds, Google Maps, web services, and much more in your applications. Using Plug-ins, Dynamic Actions, BI Publisher, translations and Websheets, you will be able to enhance your applications to a new level in APEX.

    This book will show you how to be Agile in the development of your web applications by using Team Development, debugging, and third-party tools.

    After reading this book, you will be able to create feature-rich web applications in Application Express 4.0 with ease and confidence.

    A practical reference guide with over 70 recipes for every APEX developer

    Table of Contents

    1. Oracle APEX 4.0 Cookbook
      1. Table of Contents
      2. Oracle APEX 4.0 Cookbook
      3. Credits
      4. About the Authors
      5. About the Reviewers
      6. www.PacktPub.com
        1. Support files, eBooks, discount offers and more
          1. Why Subscribe?
          2. Free Access for Packt account holders
      7. Preface
        1. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
        5. Reader feedback
        6. Customer support
          1. Errata
          2. Piracy
          3. Questions
      8. 1. Creating a Basic APEX Application
        1. Introduction
        2. Creating an APEX 4.0 application
          1. How to do it...
          2. How it works...
        3. Creating a simple form page
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more…
        4. Creating a simple report
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        5. Implementing an interactive report
          1. Getting ready
          2. How to do it...
          3. There's more...
        6. Creating a chart
          1. Getting ready
          2. How to do it...
          3. There's more...
        7. Creating a map chart
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        8. Creating a navigation bar
          1. Getting ready
          2. How to do it...
          3. There's more...
          4. See also
        9. Creating a list of values
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        10. Including different item types
          1. Getting ready
          2. How to do it...
        11. Protecting a page using an authorization scheme
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        12. Securing an application with Authentication
          1. Getting ready
          2. How to do it...
        13. Control the display of regions and items with Dynamic Actions
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        14. Creating a computation
          1. How to do it...
          2. There's more...
        15. Creating an automated row fetch with a page process
          1. Getting ready
          2. How to do it...
          3. How it works...
        16. Putting some validation in a form
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        17. Creating a report with PL/SQL Dynamic Content
          1. How to do it...
      9. 2. Themes and Templates
        1. Introduction
        2. Creating your own theme
          1. Getting ready
          2. How to do it...
          3. How it works...
        3. Importing a theme
          1. Getting ready
          2. How to do it...
          3. How it works...
        4. Creating a custom template
          1. Getting ready
          2. How to do it...
          3. There's more...
        5. Including images in your application
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        6. Referencing CSS classes in your application
          1. Getting ready
          2. How to do it...
          3. How it works...
        7. Controlling the layout
          1. Getting ready
          2. How to do it...
      10. 3. Extending APEX
        1. Introduction
        2. Adding JavaScript code to your application
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        3. Creating a tag cloud with AJAX
          1. Getting ready
          2. How to do it...
          3. How it works...
        4. Creating visual effects with JavaScript libraries
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more
        5. Enhancing your application with the Google API
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        6. Including Google maps
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        7. Embedding multimedia objects in your application
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also…
        8. Creating a region selector
          1. Getting ready
          2. How to do it...
          3. How it works...
        9. Sending mail via APEX
          1. Getting ready
          2. How to do it...
          3. How it works...
        10. Uploading and downloading files
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
      11. 4. Creating Websheet Applications
        1. Introduction
        2. Creating a websheet application
          1. Getting ready
          2. How to do it...
          3. How it works
          4. See also
        3. Creating a page in a websheet
          1. Getting ready
          2. How to do it...
        4. Adding a navigation section to a page
          1. Getting ready
          2. How to do it...
        5. Implementing a datagrid
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        6. Allowing multiple users access to a websheet
          1. Getting ready
          2. How to do it...
          3. How it works...
        7. Creating an enhanced datagrid from a spreadsheet
          1. How to do it...
          2. There's more...
      12. 5. APEX Plug-ins
        1. Introduction
        2. Creating an item type plug-in
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        3. Creating a region type plug-in
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        4. Creating a dynamic action plug-in
          1. Getting ready
          2. How to do it...
          3. How it works...
        5. Creating a process type plug-in
          1. Getting ready
          2. How to do it...
      13. 6. Creating Multilingual APEX Applications
        1. Introduction
        2. Creating a translatable application
          1. Getting ready
          2. How to do it...
          3. See also
        3. Using XLIFF files
          1. Getting ready
          2. How to do it...
          3. How it works...
        4. Switching languages
          1. Getting ready
          2. How to do it...
        5. Translating data in an application
          1. Getting ready
          2. How to do it
          3. How it works
      14. 7. APEX APIs
        1. Introduction
        2. Updating a table with the hidden primary key
          1. Getting ready
          2. How to do it...
          3. How it works...
        3. Reading a checkbox programmatically
          1. Getting ready
          2. How to do it...
        4. Creating help functionality with apex_application.help
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        5. Counting clicks with apex_util.count_click
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        6. Setting default item settings with apex_ui_default_update
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        7. Creating a background process with apex_plsql_job
          1. Getting ready
      15. 8. Using Webservices
        1. Introduction
        2. Creating a SOAP webservice reference
          1. Getting ready
          2. How to do it...
          3. How it works…
          4. See also
        3. Creating a REST webservice reference
          1. Getting ready
          2. How to do it...
          3. How it works…
          4. There's more...
        4. Building a page on a webservice reference
          1. Getting ready
          2. How to do it...
          3. How it works…
          4. There's more…
      16. 9. Publishing from APEX
        1. Introduction
        2. Exporting to a comma separated file
          1. Getting ready
          2. How to do it...
          3. How it works...
        3. Creating a PDF report
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        4. Creating a report query
          1. Getting ready
          2. How to do it...
          3. How it works...
        5. Creating a report layout using Oracle BI Publisher
          1. Getting ready
          2. How to do it...
          3. How it works...
        6. Linking the report layout to the report query
          1. Getting ready
          2. How to do it...
          3. How it works...
        7. Calling a report from a page
          1. Getting ready
          2. How to do it...
          3. How it works...
      17. 10. APEX Environment
        1. Introduction
        2. Setting up a development environment using subscriptions
          1. How to do it...
        3. Debugging an APEX application
          1. Getting ready
          2. How to do it...
          3. There's more...
        4. Debugging an APEX application remotely
          1. Getting ready
          2. How to do it...
          3. How it works
        5. Deploying an application with SQL Developer
          1. Getting ready
          2. How to do it...
        6. Setting up version control with APEX and SVN
          1. Getting ready
          2. How to do it...
        7. Setting up a production environment using an Apache proxy
          1. Getting ready
          2. How to do it...
        8. Setting up the APEX Listener on Weblogic
          1. Getting ready
          2. How to do it...
      18. 11. APEX Administration
        1. Introduction
        2. Creating a workspace manually
          1. Getting ready
          2. How to do it...
          3. How it works
        3. Creating a workspace by request
          1. Getting ready
          2. How to do it...
          3. There's more...
        4. Creating a user
          1. Getting ready
          2. How to do it...
        5. Adding a schema to your workspace
          1. Getting ready
          2. How to do it...
          3. How it works
        6. Setting a system message
          1. Getting ready...
          2. How to do it...
          3. There's more...
        7. Setting a workspace announcement
          1. Getting ready
          2. How to do it...
          3. There's more...
        8. Setting news items on the home page
          1. Getting ready
          2. How to do it...
          3. There's more...
        9. Creating a site-specific task list
          1. Getting ready...
          2. How to do it...
          3. How it works…
          4. There's more...
        10. Creating a public theme
          1. Getting ready...
          2. How to do it...
          3. How it works...
          4. There's more...
        11. Locking a workspace
          1. Getting ready...
          2. How to do it...
          3. How it works...
          4. There's more...
      19. 12. Team Development
        1. Introduction
        2. Creating a list of features
          1. Getting ready
          2. How to do it...
          3. There's more...
        3. Creating and assigning To-do's
          1. Getting ready
          2. How to do it...
        4. Keeping track of bugs in the Bugtracker
          1. Getting ready
          2. How to do it...
          3. There's more…
        5. Creating Milestones
          1. Getting ready
          2. How to do it...
        6. Using Feedback
          1. Getting ready
          2. How to do it...
          3. There's more...
        7. Using Follow-ups
          1. Getting ready
          2. How to do it…
          3. How it works
      20. Index