The year 2014 was the 10th anniversary of Oracle Application Express (APEX)
. I still find it unbelievable 10 years have pasted. Time flew by... you might think that after 10 years of building APEX applications the technology is out-dated or you get tired of it, but more the opposite is true.
Oracle Application Express is a web technology and the web evolves fast, which keeps it interesting and fun. We can follow the latest and (more...)
At Oracle Open World I gave a presentation about the integration of Microsoft Sharepoint
and Oracle Application Express (APEX)
I see a lot of companies using Microsoft Sharepoint as portal for their intranet. For many people it’s the first place they go to when they start their day. But to do their job they make also use of other applications, some which are build in Oracle Application Express (APEX). This presentation will show the different (more...)
Oracle released APEX 4.2.6
yesterday, it's also available from My Oracle Support as a patch set 19595896.
Here's the table of bug fixes.
Table 6 Bugs Fixed in the Oracle Application Express 4.2.6.00.03 Patch Set
Importing pre-4.2 application with data loading results in runtime error
APEX_WEB_SERVICE.CLOBBASE642BLOB converts incorrectly
Corrupted HTML mail messages are created from
Oracle SQL Developer
and Oracle SQL Developer Data Modeler
got a new version (4.0.3).
You can now setup an SSH tunnel in your connection - it saves you to setup a tunnel first.
This new release also feels a lot faster to me.
In previous versions of Oracle APEX (< 5.0) you could use Tabs for the navigation in your application.
Tabs were not that flexible, they were typical on top of your page in a specific look and feel. Since APEX 4.x I started to dismiss using Tabs in most of the cases, instead I would use a List with the "Page Tabs" template if people wanted that look and feel.
APEX 5.0 introduces (more...)
Over the last months different Oracle Application Express (APEX) meetups
were initiated around the world. You can read a bit of background on how the meetups started on Dan's blog
I think it's a great idea to have local meetups to meet other people working or interesting in APEX too. When you just start with APEX it's interesting to talk to other people how they got started. But equally for more seasoned developers it's a (more...)
Sunday is typically the day where the Oracle development team is on stage to talk about what they do, give insight in the product etc. - for me personally one of the highlights of the conference.The Awesome Evolution of Oracle Application Express 5.0
by Joel Kallman
Joel demoed HTML DB 1.6 again, the predecessor of APEX - went live in 2004, so 10 years ago (time goes fast!). Next he timed doing (more...)
In APEX 5.0 you (can) develop in the new Page Designer.
The Page Designer makes you way more productive, less clicks and quicker results. You have to get used to it, and you probably want a big monitor (time to ask your boss!), but once all that is done - you will love it.
The Page Designer is so intuitive and attention was put in the details. When you make a mistake APEX (more...)
With the new template, the new buttons for example are highly customisable in APEX 5.0
(icon on the left or right, spacing between, etc.)
In the Appearance section you find kinda the same options as in APEX 4.x, but when you look a bit further, there's so much more now.
You can declaratively change the way your button looks like, by clicking the Template Options:
The icons you can chose for your (more...)
Develop even faster? use the keyboard shortcuts in Oracle Application Express (APEX) - you find them defined here:
Here's the list:
- Display From HereCtrl+Option+D
- Display From PageCtrl+Option+T
- Go to Dynamic ActionsOption+2
- Go to Gallery ButtonsOption+9
- Go to Gallery ItemsOption+8
- Go to Gallery RegionsOption+7
- Go to Grid LayoutOption+5
- Go to HelpOption+F1
- Go to MessagesCtrl+F1
- Go to Page Shared ComponentsOption+4
- Go to ProcessingOption+3
- Go to Property EditorOption+6
- Go to RenderingOption+1
- Keyboard ShortcutsOption+Shift+F1
- Page SearchCtrl+Option+F
- Save and Run PageCtrl+Option+R
- Toggle Hide Empty PositionsCtrl+Option+E
For Mac users like me; the Option key is "fn" + "alt"
You can now request a workspace
in the brand-new version of Oracle APEX 5.0 (EA2).
Once requested a workspace you will get an email to activate it - and you're up-and-running!
The login screen looks awesome:
And then you see the new APEX Builder - new theme, with all new icons:
The Application Builder looks different now too - look at the nice icons and new style of Interactive Report:
Joel just blogged
that the 2nd Early Adopter release of APEX 5.0 is around the corner.
Here are some screenshots posted on twitter:
I'm sure this new EA will carry many changes and looking at some screenshots it looks awesome.
I especially look forward to the new universal theme.
Here's what should be in - based on the statement of direction
of APEX 5.0 :
Oracle Application Express 5.0
For the first Oracle APEX Cookbook
I was involved as a reviewer.
Michel and Marcel updated their book end of last year, but I didn't take the time to blog about it yet - and months fly. The concept stayed the same as the first edition, but it got updated with the latest info for APEX 4.x.
"People who followed a beginner training or learned APEX at their own and they want to (more...)
People expect these days from a public website you can authenticate with Facebook, Google+, Linkedin, Microsoft etc. It's very convenient as you don't need to create a specific account per website.Background
All of the social networks have very good documentation how to call their APIs.
Here's for example the Facebook Login
Most of the API's use the OAuth2.0
protocol, there's an application key and tokens that are send with the requests. Here's (more...)
A few weeks ago I asked my friends at RecX
to do a security audit of the World Cup 2014 Challenge
app. The result was a security assessment document which explained what they tested, an explanation why it was important and the results they found. I found it very interesting to see how other (security) people approach your code.
Here are the areas they went into:Access Control
- Hidden items
- Item Protection
- Page Access Protection
How do you show to people in different timezones the schedule in their own time?
That is the issue I had when building the wc2014challenge.com
So I started to just show the schedule in the "local time" of the stadium the match was in, so I didn't have to deal with the issue :)
But as you might think, people started to ask to see the schedule in their own time.
In previous (more...)
You remember the old days? 2006 ... APEX aka HTMLDB was still the new kid on the block!
To promote APEX at that time I build an Oracle APEX app that allowed you to see the scores of the World Cup 2006. After some feedback I created a betting piece to it... it gained much traction, it even got translated in Chinese! Here's a picture of that time:
Since then every year with the World Cup (more...)
A few days ago Oracle brought out a new patch for APEX 4.2, this will be the latest version of this build, the next version of APEX will be 5.0.
If you already have APEX 4.2.x installed you can download a patch from support.oracle.com
, the patch number is 17966818.
If you have an earlier version of APEX you can download
the full version of APEX and install that.
Yesterday a new version of the Oracle APEX Listener
was released. The new version is 2.0.6... and the biggest change in this release is the change in name. From now on we won't speak about the "APEX Listener" anymore, but we speak about "Oracle REST Data Services".
The name explains more what the piece of software is doing and it will be less confusing for non-APEX people. Many people thought about the Database (more...)
a few days ago the Oracle APEX Theming Competition.
Make an awesome APEX theme and you may win some cool prices!
In the Learning Resources
on the ODTUG site you will see a reference to my presentation of last year "Advanced Responsive Design in APEX
". In that presentation I showed a lot of live demo's from different aspects of Responsive Design: here's a quick overview of what I covered:
I made (more...)