Book Image

Oracle APEX Cookbook : Second Edition

Book Image

Oracle APEX Cookbook : Second Edition

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Oracle APEX Cookbook : Second Edition
Oct, 2013 | 444 pages
No titles found
Table of Contents (21 chapters)
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
1
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
2
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
3
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
4
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
5
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
6
Creating Multilingual APEX Applications
Creating Multilingual APEX Applications
Introduction
Creating a translatable application
Using XLIFF files
Switching languages
Translating data in an application
7
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
8
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
9
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
10
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
11
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
12
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
13
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
14
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

Translating data in an application

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

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.

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

Previous Section
End of Chapter 6
Next Chapter