Oracle APEX 4.0 Cookbook

Oracle APEX 4.0 Cookbook

By : Michel Van Zoest, Marcel Van Der Plas

Buy this Book

Oracle APEX 4.0 Cookbook

By: Michel Van Zoest, Marcel Van Der Plas

Buy this Book

Overview of this book

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.

Oracle APEX 4.0 Cookbook

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

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

Control 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

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

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

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 Multilingual APEX Applications

Introduction

Creating a translatable application

Using XLIFF files

Switching languages

Translating data in an application

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 Webservices

Introduction

Creating a SOAP webservice reference

Creating a REST webservice reference

Building a page on a webservice reference

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

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 Weblogic

APEX Administration

Introduction

Creating a workspace manually

Creating a workspace by request

Creating a user

Adding a schema to your workspace

Setting a system message

Setting a workspace announcement

Setting news items on the home page

Creating a site-specific task list

Creating a public theme

Locking a workspace

Team Development

Introduction

Creating a list of features

Creating and assigning To-do's

Keeping track of bugs in the Bugtracker

Creating Milestones

Using Feedback

Using Follow-ups

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Translating data in an application

Besides the application labels, there is more to translate in an application. Data for instance.

In this recipe, we will see an example of this. To accomplish this, we will use a built-in way of translating the session language that is new in APEX 4.0.

Getting ready

Start by creating some new database objects. Remember that this is a crude setup. In a production environment, this should be more elaborate.

First, we will create a copy of the EMP table, but with a change. The JOB column will now be called JOB_NO and it's content will reference to a EMP_JOB_TITLES table.

create table EMP_LANG
(
  empno    NUMBER(4) not null,
  ename    VARCHAR2(10),
  job_no   NUMBER,
  mgr      NUMBER(4),
  hiredate DATE,
  sal      NUMBER(7,2),
  comm     NUMBER(7,2),
  deptno   NUMBER(2)
);

[emp_lang.sql]

Also create the EMP_JOB_TITLES table. This table contains a LANGUAGE column that will hold the language in which the job_title is entered for that row.

This also means...

Oracle APEX 4.0 Cookbook

By : Michel Van Zoest, Marcel Van Der Plas

Oracle APEX 4.0 Cookbook

By: Michel Van Zoest, Marcel Van Der Plas

Overview of this book

Related Content you might be interested in

Current Title:

Oracle APEX 4.0 Cookbook

Translating data in an application

Getting ready