For the last 15 years, with every big football tournament (World Cup and Euro Cup), we've launched an Oracle APEX app where you can predict the scores of the games. You can find this year's app at https://euro2020.unitedcodes.com
Many people do a challenge with their friends or company, for fun, for money... Instead of using a custom-made Excel, use of email, or use of paper, you can use the Euro 2020 Challenge site to track who's in the lead.
- You can enter the scores of every game and see how well your predictions compare to others (overall).
- You can create a group e.g. your company, or a team, etc and see how well you play within your group.
- You can see statistics of predictions
15 years ago, I built a site to promote the use of Oracle APEX. People loved it, so I decided to update the site with every new release of APEX. You can find some more history and screenshots of how the app looked here. Not that many changes have been done compared to the app from 2018, but this year it runs on Oracle APEX 21.1, so it shows that upgrading APEX apps is smooth.
Oracle APEX features
When upgrading to the new Oracle APEX version, the Advisor and Upgrade assistant were run. Some plug-ins (e.g. select2) got replaced by built-in features (e.g. Inline Pop-up). Most changes were done in the Admin section, where tabular forms were replaced by Interactive Grids, native Forms regions are now being used, and other parts that showed up in the upgrade assistant were applied.
Social authentication was updated, so you can sign-up and log in with Email, Facebook or Google.
Normally with an upgrade, we also update the Universal Theme version, but as it's using a custom theme we didn't do it for this app.
Go and play!
So, now head to the site/app and start challenging your friends!