nobody Have a Question? Help Login
  • Home
  • Content Details

Application Express Release 4.1 Series


1 user(s) recommend this content

Content List (click links below to view content)

12-SEP-2012 30 mins

Manipulating Database Objects Using Oracle Application Express 4.1

This tutorial shows you how to manipulate database objects using Oracle Application Express.

19-AUG-2011 60 mins

Creating and Running a Database Application Using Oracle Application Express 4.1

This tutorial shows you how to rapidly create and manipulate pages in a database application using Oracle Application Express.

23-AUG-2011 30 mins

Adding Additional Components to your Existing Database Application Using Oracle Application Express 4.1

This tutorial shows you how to add additional components to your existing database application.

26-AUG-2011 50 mins

Using Interactive Report Regions in Application Express 4.1

Interactive Reports allow developers to define queries that can be highly customized by end-users. Users can customize the layout of the data by choosing the columns they are interested in like, applying filters, highlighting, and sorting. They can also define breaks, aggregations, computed columns and include a chart of the query results. Users can create multiple variations of the report and save them as named reports, output to comma-delimited files, and print to PDF documents.

26-AUG-2011 60 mins

Building and Customizing an Interactive Report in Application Express 4.1

Interactive Reporting Regions enable end users to customize reports. Users can alter the layout of report data by choosing the columns they are interested in, applying filters, highlighting, and sorting. They can also define breaks, aggregations, different charts, and their own computations. Users can create multiple variations of the report and save them as named reports and download to various file formats including comma-delimited file (CSV) format, Microsoft Excel (XLS) format, Adobe Portable Document Format (PDF), and Microsoft Word Rich Text Format (RTF). For further information, click on help and search on Interactive Reports. Another feature shown in this tutorial is Application Date Format. You can define a date format that will be used throughout your application. This date format will be used to alter the NLS_DATE_FORMAT database session setting prior to showing or submitting any page within the application. This format is used by all reports showing dates and is also picked up by form items of type 'Date Picker (use Application Date Format)'. This can be set using: 1. Application Builder > Application Builder Defaults (under Tasks): These are specific to a Workspace, not a developer, and will be used as the default when using the create application wizard. 2. Application Builder > Create Application Wizard > Attributes page 3. Application Builder > Your Application > Shared Components > Edit Globalization Attributes This tutorial shows the developer how to create and customize an Interactive Report for an end user.

29-AUG-2011 50 mins

Utilizing Advanced Interactive Report Region Techniques in Oracle Application Express 4.1

In this tutorial, you explore some of the more advanced tasks related to Interactive Report Regions in Oracle Application Express such as resetting your interactive report manually, created a declarative filter and a derived column.

22-AUG-2011 15 mins

Creating a Data Load Wizard for Your Application with Oracle Application Express 4.1

Applications with data loading capability allow end users to dynamically import data into a table within any schema to which the user has access. To do this, end users run a Data Load Wizard that uploads data from a file or copies and pastes data entered by the end user directly into the wizard. With Oracle Application Express 4.1, you can create a series of data load wizard pages in your application using the new Data Loading page wizard. The wizard allows you to add table lookups and transformation rules that are executed when the Data Load Wizard runs. In this tutorial, you create a DEPENDENTS table, create an application with a report, use the Data Loading page wizard to create the Data Load wizard pages in your application that the end user uses to load the data. The Data Loading definition contains a table lookup for the relative name and a data transformation rule to make sure that Gender is stored in uppercase.
24-AUG-2011 60 mins

Building Dynamic Actions in Oracle Application Express 4.1

In APEX, Dynamic Actions provide developers with a way to define client-side behavior declaratively without the need to know JavaScript. Using a simple wizard, developers can select a page item, a condition, enter a value, and select an action (for example, Show, Hide, Enable, and Disable). Previously, this involved hand crafting JavaScript and AJAX but now many Dynamic Actions require zero coding using the built-in wizards.
25-AUG-2011 60 mins

Building a Websheet Application in Application Express 4.1

This tutorial shows you how to build, use, and customize a Websheet Application in Oracle Application Express 4.1.
25-AUG-2011 60 mins

Manipulating a Data Grid in a Websheet Application

This tutorial shows you how to use and manipulate a datagrid in a Websheet Application in Oracle Application Express 4.1.
25-AUG-2011 30 mins

Interacting With the Database From a Websheet Application

This tutorial shows you how to interact with the database from a Websheet Application in Oracle Application Express 4.1.

Please Log In to Bookmark this OBE

Bookmarked 28 times

 
1 user(s) recommend this content

Hide/Show Reviews

rsoule 3.4 years ago
<p> Combined, this series gives folks a great way to get an introduction to Oracle Application Express 4.1. Most of the lessons are very good to great.</p>
  • Login to add a reply

Hide/Show Related OU Courses

Hide/Show Additional Resources