Cloud Computing Using Oracle Application Express: Develop Internet-Facing Business Applications Accessible Anywhere and Anytime

By Riaz Ahmed

Get the domain knowledge you need to develop real-world business apps for and in the cloud. You’ll see how Oracle APEX has made the life of web developers much easier and how it helps you create web-based data-centric applications easily and instantly without writing screeds of code.

In Cloud Computing Using Oracle Application Express, you will develop a complete general ledger accounting system named the Cloud Accountant which will be accessible through a variety of devices including desktops, laptops, and the latest smartphones. 

This new edition also incorporates the new application page creation process, which differs from the previous version. You’ll cover other new areas, such as the updated UI elements and properties, and the interactive grid. Besides the development of a full application that you can deploy in your organization, the book teaches many new techniques to further enhance your APEX development skills.

What You Will Learn

• Discover new development techniques for APEX developers
  
• Develop cloud-based ERP applications
  
• Build a cloud-based application on Oracle APEX
  
• Integrate the free JasperReports server and report designing tool with Oracle APEX
  

Who This Book Is For

Web developers who possess some working knowledge of Oracle Application Express, and developers who have been using Oracle Forms and now wish to use their existing SQL and PL/SQL expertise.

• Language: English
• Publisher: Apress
• Release date: Nov 28, 2018
• ISBN: 9781484242438

Riaz Ahmed

Riaz Ahmed is an IT professional with over twenty years of hard-earned experience. He started his career as a programmer in early 90's and is currently working as the head of IT with a reputed group of companies. He has been working in Oracle technologies since 1996. Besides Oracle database, his areas of interest are Oracle's web-based development technologies including APEX, JDeveloper, Business Intelligence, and JHeadstart. He has authored couple of books on Oracle technologies. These books are taught in U.S community colleges and IT institutes. His first book, Create Rapid Web Applications Using Oracle Application Express, is listed on Oracle Corporation’s web site. The second one, Implement Oracle Business Intelligence (Volume 1), is a hands-on guide written on OBIEE.

Book preview

© Riaz Ahmed 2019

Riaz AhmedCloud Computing Using Oracle Application Expresshttps://doi.org/10.1007/978-1-4842-4243-8_2

2. Application Navigation

Riaz Ahmed¹ 

(1)

Karachi, Pakistan

Previous versions of APEX used tabs that acted as an application’s main menu up to version 4.2. In APEX 18.1, a default navigation list named the desktop navigation menu is created automatically as a shared component for each new application. This provides the user with a hierarchical set of pull-down menus and submenus. It is displayed as a responsive sidebar. Based on the available space, the navigation bar either displays as a full menu or collapses to a narrow icon bar.

2.1 Create the Main Application Menu

The default desktop navigation menu carries just one item (Home). In this chapter, you’ll modify this list to add more application menu entries. Follow these instructions to complete this exercise:

1.

In Shared Components, click the Lists option in the Navigation section.

2.

Select the Desktop Navigation Menu option, which carries a default entry (Home) created by the application builder wizard. Modify this entry by clicking its name. In the attributes page of the Home menu item, click the pop-up LOV icon to the right of the Image/Class attribute to display a list of possible icon images for the Home menu option. At the top of the icon list you will notice two options: Show and Category; set Show to Font Awesome Icons, and set Category to Web Application. Click the Go button to refresh the view and then select the fa-home icon from the icons list. This image will be displayed for the Home menu at run time. Hit the Apply Changes button to save your work. With practice you will get to know the icon names and can type them directly in the Image/Class attribute to save time. If you do not see the specified icon, select anyone you like from the list.

3.

Click the Create List Entry button to create a new menu item. Enter the values shown in Table 2-1 against the specified attributes. You won’t select anything for the first attribute (Parent List Entry) because initially you will create Level 1 entries that do not have parent entries. The target is either a page in the current application or any valid URL. In this case, the Setup menu entry itself is not associated with any application page, so its Target Type is set to No