Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 








ApEx (HTML-DB) release 3 new features

Oracle Database Tips by Donald Burleson

Oracle Apex has become a leading package for the fast and easy development of browser-based applications.  We also recommend the book "Easy Oracle Application Express" for getting started fast developing applications with ApEx.

Oracle Application Express 3.0 has a Pre-release download, and it lists these new features:

PDF Printing - You can now include the ability to export a report region to PDF - essentially, printing a report. When you click to edit a report region, you will notice a new tab, Print Attributes.

Access Migration to HTML-DB - A few months ago, we released an evaluation of our new Application Migration Workshop. . . To access the new component, select Application Migrations from the Home page.

Apex Flash Charts - When you select to create a new page or region of type chart, you will see a new type - Flash Chart. There are 18 types of charts that are supported and during the creation process, you can preview the selected type and set most attributes for your resulting chart.  . .

Drag and Drop Screen Item Layout - On the Page Definition page, you will notice a new icon to the right of the Reorder Items icons. This icon, Drag and Drop, brings you to the new Drag and Drop Item Layout feature. You can reorder items with the current region, change select attributes (item name, label, and type within the current item-type range), delete items and quickly create new items. You can place items to the left or right of an existing item and can insert a new row to quickly add items in the middle of an existing form.  . .

Improved Apex Web Services - The Application Express Web services engine now supports more loosely defined types and document style Web services. Both enhancements make it possible to support JDeveloper created Web services and Oracle BPEL synchronous Web services. It is now also possible to interact with Web services over SSL (HTTPS) and Web services that require basic authentication.  . .

New HTML-DB Item Types - Several new items types have been added. These include:

- Shuttle
- HTML Editor Minimal - available under Textarea
- HTML Editor Standard - available under Textarea
- Popup Color Picker - available under Popup List of Values
- Date Picker (use format mask)

Apex Calendar Enhancement - Now, when you create a calendar page or region, you will automatically get a Monthly, Weekly, and Daily Calendar. The user will be able to toggle between the mode that they want using buttons.

Supporting Objects Enhancement - The Supporting Objects feature that was introduced in Application Express 2.2 has been enhanced to allow for the definition of upgrade scripts.

Page and Region Caching in HTML-DB - Page and Region caching allows you to write parts of your application to a cache to improve performance. The cache attributes are set on the Page and Region attributes pages. . .

Item Finder Enhancements - From within the Application Builder, there are two new tabs on the Item Finder. One for CSS - this allows you to identify cascading style sheets that are available to any Application Express application, regardless of theme. The second is for Images - it displays an Icon gallery of generic art for use with applications.

Apex Application and Schema Comparison utility - The new Application Comparison utility is found under Application Reports > Cross Application. It can be used to identify differences between two selected applications. The Schema Comparison is found under Utilities. It is used to identify differences between objects in two different schemas.

Friendly URL Syntax to Facilitate Bookmarks - This feature allows links to use a session ID of zero for public applications. This makes all public page links consistent which makes them much more search engine and bookmark friendly.

New ApEx Password and Account Controls - At the instance and Workspace level, you can now specify rules for password expiration, mandate strong passwords (minimum number of characters, containing number and letters, etc), require change password on first use (very useful for system generated initial passwords), and lock accounts.

Improved HTML-DB Workspace Management
- In addition to the password controls above, we have made several other workspace management improvements. You can now define the sizes that you want for your workspaces (selection presented to the user requesting and the default that will be selected), request an email of your Workspace Names (how many of us have workspaces out that that we just can't recall the name of but we always know our email address), and review a log of login attempts.


If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.



Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.