Oracle APEX 5.0 New Features Tutorial

Watch this free video tutorial and take the APEX 5.0 for a test drive. We will demonstrate the new Universal Theme, Page Designer, built-in support for Modal Windows, the new and very cool Theme Roller, Interactive Report enhancements and many other features that make APEX 5.0 so awesome. This webinar is intended for developers who have already built applications with Orace Application Express.

Presenter: Certified Oracle APEX Expert Tyson Jouglet

Language: English

Be sure to set the Youtube settings to High Definition. For best viewing, also watch in full screen mode.

  1. Experience the new login with Oracle SSO and the very helpful List of Workspaces (demonstration) (4:55)
  2. New Application Builder and Responsive Theme (demonstration) (1:33)
  3. APEX 5 Theme Roller Demonstration (5:59)
  4. (it is a mystery, what happened to Lesson 4! ) (0.00)
  5. Integrating Font Awesome (scalable vector icons) (4:17)
  6. Modal Pop-Ups in APEX 5.0 (4:03)
  7. Page Designer (8:05)
  8. Plug-Ins (6:41) (click on video below)
  9. Interactive Reports (8:02)

Date: Feb 17, 2015

NOTE: Some corporate firewalls will not allow videos hosted by YouTube.



Introduction to APEX 5 New Features


Lesson 8 – Plugins


>> Tyson:  Now, very quickly, we’re going to navigate to plugins.




Here is a plugin that you can find. It’s called the slide tooltip plugin. It’s in the sample application. I’m just going to touch on a few things for those of you who may be are developing plugins or want to get into building plugins, or if you’re using plugins, how your experience is going to get better as new plugins are created.


One thing that is really, really awesome to me is that here we have something, a plugin, that looks like a report. It has tabular data in addition to a tooltip which is the extra data.




But you would likely get all this information from a query. Previously, if you had tabular data in a plugin, there was no way of looking at or modifying columns individually unless the developer of that plugin did a whole lot of work to allow you to do that. And the experience wasn’t the same as what you come to know with default APEX reports.




Let me show you what I’m talking about. This plugin, you can now see, exposes all the columns that it has access to. I can go in and I can sequence how these columns are going to show up. I can change the heading of these columns. I can say whether or not I want this to show so I can say, “STREET ADDRESS 2, no. I don’t want you to show up.”




Let me go back to grid layout so I can see what my page looks like.




Run my page. It’s going to apply these changes.


You may get this error every now and then. It’s not really an error, just more of an alert. It says, “The changes have been saved but it failed to refocus on the new tab.” So I’m going to click on “Try Again” and it’s going to let me refocus on the new tab.


It’s hard to tell but the fourth line in the tooltip is no longer CUST_STREET ADDRESS 2. It is no longer showing up. So you modified how this plugin is behaving and how a column of this plugin is behaving in a more APEX declarative fashion.




I just want to show you as an already plugin developers out there, I’m going to navigate to shared components. I’m going to go to plugins. I’m going to find the slide tooltip plugin.




Don’t worry about the code so much here. But do you notice that it is highlighted? We can see that there is some styling here. Remember this is an early adopter, so the spacing here is a little goofy but that’s okay. It’s early adopter, we know that things aren’t always going to be perfect. But do know that there is syntax highlighting. And you’ll see more syntax highlighting in all of the source of the different APEX items.


But one thing that I want to show you is here. This is the option that allowed this really cool stuff to happen. It says, “Has region columns” and “Has heading column attribute.” By checking this on your plugin, basically what this does is APEX will go ahead and query the data for you and give you all the data and headings attached to the payload that it delivers to you to leverage all the built-in APEX attributes.




One last thing I want to touch on here in plugins – this isn’t plugin specific but it’s something that I think is really cool. I’m going to refresh this and see if it will fix the formatting here. It did. Very cool.




One thing that we now have access to is there’s a package – this is kind of small, let me see if I zoom in. There’s a package called APEX JSON. APEX team has given us the package to use if we need to generate JSON output.


Notice here, you can see that it’s coined the object. It’s writing some values. Here it’s saying open_array. Now it’s writing an array of values.


That’s pretty cool in that we now have a package to help generate JSON. There are some other utility in that package that we’re not going to talk about but it’s really cool.


Some of you might be asking, “What is JSON? What does it look like? Why is it important? Why would I use it?” If you look at this plugin – let me restore. I’m going to open up my network tab and I’m going to refresh my page. Here you can see this is the JSON structure that was generated.




This is the structure for Bradley Eugene. Here’s all the other information related to him. Pretty cool. APEX helped us generate that.




User experience with plugins, as well as developer options are becoming way better with plugins.


Copyright 2017

Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!