Oracle APEX 23 Course For Beginners

Oracle APEX 23 Course For Beginners
Oracle APEX 23 Course For Beginners

Monday 12 June 2017

Interactive Grid Features In Oracle APEX 5.1

Oracle APEX 5.1 comes with a new feature called Interactive Grid to display data in row/column matrix. In appearance, it looks similar to an Interactive Report (used in the next chapter) and delivers all features of an Interactive Report, but it also allows you to manipulate data simply by clicking on a cell and editing its value, which is not available in Interactive Reports.  In many ways this grid looks and acts like an Interactive Report. Here are some new features and differences:

  • Rows are fixed height and columns have a specific width that can be adjusted by dragging the border between column headers (G) or with Ctrl+Left/Right keys when the column header has keyboard focus.
  • Columns can be reordered with drag and drop (dragging the handle (E) at the start of a column heading) or with Shift+Left/Right keys when the column header has keyboard focus.
  • Columns can be sorted using the buttons (F) in the column heading or by using Alt+Up/Down key combination. Use the Shift key to add additional sort columns.
  • Columns can be frozen using the Freeze button  (D) in the column heading pop-up menu. For example, to freeze the customers’ name column (on Page 2), click the Name column heading. A pop-up menu will appear with four options: Hide (A), Control Break (B), Aggregate (C), and Freeze (D). Select Freeze. Drag the border between the Name and Address columns (F) toward right to expand the Name column.
  • By default the toolbar and column headings stick to the top of the page and the footer sticks to the bottom when scrolling.
  • By default pagination uses a "Load More" button.
  • The grid is keyboard navigable with a focused cell and current selected row (single selection by default).
  • The toolbar includes a Reset button by default, which restores all the report settings to their defaults.


To explore the features of the new Interactive Grid, you need a couple of tables that come with a sample application. Execute the following steps to install the sample application and consequently the required tables.


  1. Select Sample Apps from the Packaged Apps menu appearing at the top of your browser.
  2. Click the icon representing Sample Interactive Grids application.
  3. On the Packaged App Details page, click the Install Packaged App button.
  4. On the Install Packaged App wizard screen, accept the default Authentication scheme (Application Express Accounts) and click Next.
  5. On the next wizard screen, click the Install Packaged App button. After a while, you will see the message Application installed.
  6. Click the Object Browser option in the SQL Workshop main menu and see the two required tables (EBA_DEMO_IG_EMP and EBA_DEMO_IG_PEOPLE) in the left pane under the Tables category.


The instruction provided in this post are extracted from the book Oracle Application Express 5.1 Basics & Beyond








Thursday 8 June 2017

Using Master Detail And Detail And Detail in Oracle APEX


Interactive Grid makes it effortless to create master-detail relationships and go any number of levels deep and across. You can create all types of master-detail-detail screens with ease. In this post, I’ll demonstrate this new feature.


1.   From the SQL Workshop menu, select SQL Scripts and click the Upload button. In the Upload Script screen, click the Choose File button. In the Open dialog box, select master_detail_detail.sql file from the Chapter 5 folder in the book’s source code and click Open. Enter Master Detail Detail in the Script Name box and click the Upload button. In the SQL Scripts interface click the Run button appearing in the last column. On the Run Script screen, click the Run Now button. The script will execute to create four tables (MD_continent, MD_country, MD_city, and MD_population) along with relevant data to demonstrate the new master detail detail feature. You can view these tables from the SQL Workshop > Object Browser interface.

2.    Create a new page by clicking the Create Page button in the App Builder interface. This time, select the first Blank Page option and click Next. Set Page Number to 112, Name to Master Detail Detail, Page Mode to Normal, and click Next. On the Navigation Menu screen, select the first Navigation Preference to not associate this page with any sales app navigation menu entry. On the final wizard screen, click Finish.

3.     In the Page Designer, right-click the Regions node on the Rendering tab and select Create Region. Set the following properties for the new region. This region will display data from the MD_continent table.
Property
Value
Title
Continents
Type
Interactive Grid
SQL Query
select * from MD_continent
After entering the SQL query, click anywhere outside the query box. Expand the Columns folder under this region. Click the CONTINENT_ID column. Set its Type to Hidden and set Primary Key (under Source) to Yes. You must define a primary key column for an interactive grid region, which is required to establish a master-detail relationship.

4.      Create another region under the Continents region by right-clicking the main Regions node. This region will act as the detail for the Continents region. At run-time when you select a continent, this region will display a list of countries in the selected continent. Set the following properties for this new region.
Property
Value
Title
Countries
Type
Interactive Grid
SQL Query
select * from MD_country
Expand the Columns folder under the Countries region. Click the COUNTRY_ID column. Set its Type to Hidden and set Primary Key (under Source) to Yes. You set the Primary Key property to Yes because this region will act as a master for the Cities region created in the next step. Now, associate this detail region with its master (Continents). Click the Countries region and set the Master Region property (under Master Detail) to Continents. This should be set when this region is the detail region in a master-detail relationship with another region on the page. For the master-detail relationship to work correctly, you must also select the column(s) in the detail region, which are foreign keys to the master region, by setting the Master Column property. Click the CONTINENT_ID column (a foreign key) in the Countries region. Set its Type property to Hidden and Master Column (under Master Detail) to CONTINENT_ID, which references the same column in the master region.

5.      Create another region and place it under the Countries region. This region will show a list of cities when you select a country from its master region. Set the following properties for this region:
Property
Value
Title
Cities
Type
Interactive Grid
SQL Query
select * from MD_city
Master Region
Countries
Expand the Columns folder under the Cities region. Click the CITY_ID column. Set its Type to Hidden and set Primary Key (under Source) to Yes. Click the COUNTRY_ID column in this region. Set the Type of this column to Hidden and Master Column to COUNTRY_ID to point to the same column in the Countries region.

6.      Create the last region to display the population of a city.
Property
Value
Title
Population
Type
Interactive Grid
SQL Query
select * from MD_population
Master Region
Cities
Expand the Columns folder under the Population region. Click the POPULATION_ID column. Set its Type to Hidden. Since this is the last region, you do not need to specify this column as a primary key. However, you have to set a couple of properties for the CITY_ID column in this region to associate it with its master. Click the CITY_ID column, set its Type property to Hidden, and Master Column to CITY_ID. That’s it!

Run the page and click the row representing Europe (A) in the first region. As you click this row, the second region will display countries in the Europe continent. Click Germany (B) in the second region. This will refresh the third region with a list of cities in Germany. Click Berlin city (C) to see its population (D) in the fourth region.










Friday 20 January 2017

New Book on Oracle Application Express 5.1

Oracle Application Express 5.1 Basics & Beyond


 Oracle APEX 5.1
You will find stuff about workspace, application, page, and so on in every APEX book. But this book is unique because the information it contains is not available anywhere else! Unlike other books, it adopts a stimulating approach to reveal almost every feature necessary for the beginners of Oracle APEX and also takes them beyond the basics.
As a technology enthusiast I write on a variety of new technologies, but writing books on Oracle Application Express is my passion. The blood pumping comments I get from my readers on Amazon (and in my inbox) are the main forces that motivate me to write a book whenever a new version of Oracle APEX is launched. This is my fifth book on Oracle APEX (and the best so far) written after discovering the latest 5.1 version. As usual, I’m sharing my personal learning experience through this book to expose this unique rapid web application development platform.
In Oracle Application Express you can build robust web applications. The new version is launched with some more prolific tools to maximize developers’ productivity. Once again, I’ve left out the boring bits and have adopted the same practical inspirational approach that has exposed the anatomy of Oracle Application Express to thousands of beginners in the past.
The most convincing way to explore a technology is to apply it to a real world problem. In this book, you’ll develop a sales web application that not only reveals the anatomy of Oracle Application Express, but at the same time provides hands-on techniques that build a solid foundation for you to become a web developer.
Since there are lots of changes in the new version, all content has been revised to slot in these changes, including the features new to version 5.1. The short list below summarizes the features of Oracle APEX 5.1 covered in this book:
  • Hands-on exposure to the new features, such as Interactive Grid, Oracle JET Charts, the new declarative Master-Detail-Detail capabilities, dozens of new properties, and new development procedures
  • Teaches how to rapidly develop data-centric web application for desktops, laptops, tablets, and latest smartphones
  • Produce highly formatted PDF reports, including invoices, grouped reports, and pivot tables (not covered in any other APEX book)
  • Design and implement a comprehensive custom security module (unique to this book)
  • Step-by-step instructions to create mobile version of the application using existing desktop application pages (not covered in any other beginner’s guide)
This is a concise yet a concrete book on Oracle Application Express, written for those who want to become web application developers. The sticky inspirational approach adopted in this book not only exposes the technology, but also draws you in and keeps your interest up till the last exercise. I’m grateful to all my readers whose helpful feedback enabled me to further polish my work in this edition.

Display Data Dynamically In A Gauge Chart

In this tutorial, we will learn how to display customer's ordered data in a gauge chart dynamically. As you choose a customer name from ...