Oracle APEX Cookbook · 2nd Edition by Plas, Marcel van der -- Read -- Imperial Library of Trantor

Index

Oracle APEX Cookbook Second Edition

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...

Debugging an APEX application remotely

Getting ready How to do it... How it works... There's more…

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 Tomcat

Getting ready How to do it... There's more…

Creating an error handling

Getting ready How to do it… How it works...

Using packaged applications

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 up a system message

Getting ready How to do it... There's more...

Setting up a workspace announcement

Getting ready How to do it... There's more...

Setting up 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…

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...

Creating table APIs

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-dos

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...

13. HTML5 and CSS3

Introduction Using a responsive HTML5 and CSS3 template

Getting ready How to do it... How it works... There's more... See also

Creating a form with HTML5 item types

Getting ready How to do it... How it works... There's more... See also

Creating a UI with drag-and-drop

Getting ready How to do it... How it works...

Creating storage events

Getting ready How to do it... How it works...

Geolocation – creating a tracker

Getting ready How to do it... How it works...

Creating a video plug-in

Getting ready How to do it... How it works...

Creating HTML5 charts

Getting ready How to do it... How it works...

14. Mobile

Introduction Creating a smartphone application

Getting ready How to do it... How it works... There's more... See also

Creating a hybrid application

How to do it... How it works...

Creating a list view report

Getting ready How to do it... How it works... There's more...

Creating a mobile form

Getting ready How to do it... There's more... See also

Using mobile item types

Getting ready How to do it... There's more... See also

Creating a mobile calendar

Getting ready How to do it... How it works... There's more...

Creating a date scroller with the Mobiscroll plug-in

Getting ready How to do it... How it works… There's more...

Uploading images using the camera on the device

Getting ready How to do it... How it works... There's more...

Using jQuery Mobile to fetch current GPS location

Getting ready How to do it... How it works... See also

Creating swipe events

Getting ready How to do it... How it works… There's more...

Index

← Prev
Back
Next →

← Prev
Back
Next →