Publishing from APEX | Oracle APEX Cookbook : Second Edition

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Oracle APEX Cookbook : Second Edition

4.6 (7)

Oracle APEX Cookbook : Second Edition

4.6 (7)

Overview of this book

Oracle APEX Cookbook Second Edition

Oracle APEX Cookbook Second Edition

Credits

Credits

About the Authors

About the Authors

About the Reviewers

About the Reviewers

www.PacktPub.com

www.PacktPub.com

Preface

Preface

Free Chapter

Creating a Basic APEX Application

Creating a Basic APEX Application

Introduction

Creating an APEX 4.0 application

Creating a simple form page

Creating a simple report

Implementing an interactive report

Creating a chart

Creating a map chart

Creating a navigation bar

Creating a list of values

Including different item types

Protecting a page using an authorization scheme

Securing an application with Authentication

Controlling the display of regions and items with Dynamic Actions

Creating a computation

Creating an automated row fetch with a page process

Putting some validation in a form

Creating a report with PL/SQL Dynamic Content

Themes and Templates

Themes and Templates

Introduction

Creating your own theme

Importing a theme

Creating a custom template

Including images in your application

Referencing CSS classes in your application

Controlling the layout

Extending APEX

Extending APEX

Introduction

Adding JavaScript code to your application

Creating a tag cloud with AJAX

Creating visual effects with JavaScript libraries

Enhancing your application with the Google API

Including Google Maps

Embedding multimedia objects in your application

Creating a region selector

Sending mail via APEX

Uploading and downloading files

Calling APEX from an Oracle Form

Creating a data upload page

Using shipped files

Creating Websheet Applications

Creating Websheet Applications

Introduction

Creating a websheet application

Creating a page in a websheet

Adding a navigation section to a page

Implementing a datagrid

Allowing multiple users access to a websheet

Creating an enhanced datagrid from a spreadsheet

APEX Plug-ins

APEX Plug-ins

Introduction

Creating an item type plug-in

Creating a region type plug-in

Creating a dynamic action plug-in

Creating a process type plug-in

Creating an authorization plug-in

Creating Multilingual APEX Applications

Creating Multilingual APEX Applications

Introduction

Creating a translatable application

Using XLIFF files

Switching languages

Translating data in an application

APEX APIs

APEX APIs

Introduction

Updating a table with the hidden primary key

Reading a checkbox programmatically

Creating help functionality with apex_application.help

Counting clicks with apex_util.count_click

Setting default item settings with apex_ui_default_update

Creating a background process with apex_plsql_job

Using Web Services

Using Web Services

Introduction

Creating a SOAP web service reference

Creating a REST web service reference

Building a page on a web service reference

Publishing a RESTful web service

Publishing from APEX

Publishing from APEX

Introduction

Exporting to a comma-separated file

Creating a PDF report

Creating a report query

Creating a report layout using Oracle BI Publisher

Linking the report layout to the report query

Calling a report from a page

APEX Environment

APEX Environment

Introduction

Setting up a development environment using subscriptions

Debugging an APEX application 

Debugging an APEX application remotely

Deploying an application with SQL Developer

Setting up version control with APEX and SVN

Setting up a production environment using an Apache proxy

Setting up the APEX Listener on Tomcat

Creating an error handling

Using packaged applications

APEX Administration

APEX Administration

Introduction

Creating a workspace manually

Creating a workspace by request

Creating a user

Adding a schema to your workspace

Setting up a system message

Setting up a workspace announcement

Setting up news items on the home page

Creating a site-specific task list

Creating a public theme

Locking a workspace

Creating table APIs

Team Development

Team Development

Introduction

Creating a list of features

Creating and assigning To-dos

Keeping track of bugs in the Bugtracker

Creating Milestones

Using Feedback

Using follow-ups

HTML5 and CSS3

HTML5 and CSS3

Introduction

Using a responsive HTML5 and CSS3 template

Creating a form with HTML5 item types

Creating a UI with drag-and-drop

Creating storage events

Geolocation – creating a tracker

Creating a video plug-in

Creating HTML5 charts

Mobile

Mobile

Introduction

Creating a smartphone application

Creating a hybrid application

Creating a list view report

Creating a mobile form

Using mobile item types

Creating a mobile calendar

Creating a date scroller with the Mobiscroll plug-in

Uploading images using the camera on the device

Using jQuery Mobile to fetch current GPS location

Creating swipe events

Index

Index

Creating a report query

The report in the previous recipe was rather simple. You see a table with headers and data and that's it! Nothing more, nothing less. But we want a nice, good looking report with headers and footers. Fortunately, APEX offers a way to design reports with a custom layout using Microsoft Word and Oracle BI Publisher. The first step is to define the query the report should be based on. We will do that in this recipe.

Getting ready

Make sure you have access to the APP_CUSTOMERS table.

How to do it...

Go to Shared Components.
In the Report section, click on the Report queries link.
Click on the Create button.
In the Report Query Name field, enter a name for the query. Enter rq_customers. Click on Next.

In the SQL query textarea, enter the following query:

Select cust_first_name
,           cust_last_name
,           cust_street_address1
,           cust_postal_code || ' ' || cust_city "city"
,           cust_state
From app_customers
[9672_09_02.sql]

Click on Next.
In the next step...

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Oracle APEX Cookbook : Second Edition

Search

Your notes and bookmarks