|
| 25-JUL-2019 | APEX On Autonomous | YouTube Video | APEX Product Manager David Peake will walk you through how easy it is to get started with APEX on Autonomous, and then cover how to set up other developers. Lastly, he will cover off how to migrate from on-premises to your new Autonomous Database.
Video Highlights:
[2:10] Create ATP-S Database
[5:55] Starting the Service Console
[7:45] Downloading Oracle Instant Client
[13:25] Moving Wallet files into Instant Client /network/admin
[15:35] Setting Client Credentials
[16:30] Using Import Dump
[17:50] Signing into APEX for the 1st time
[19:30] Creating other users
[21:10] Signing in as a Developer
[24:10] Post-import, updating the schema password
[25:45] Creating a Workspace for the imported schema
[27:55] Installing App Archive Packaged App
[29:55] Restoring Applications
[35:30] Q & A | David Peake | david.peake@oracle.com |
| 13-JUN-2019 | Oracle Application Express and Multitenant | YouTube Video | Oracle Multitenant, first available in Oracle database 12c, over five years ago, delivers a new architecture that allows a multitenant container database to hold many pluggable databases. This presentation will provide an overview of this database feature and will go into detail about what this means for APEX installations. Exciting tips and tricks will be covered as well as a new installation option available in APEX 19.1 to exploit the Application Containers feature of Multitenant. | Jason Straub | jason.straub@oracle.com |
| 16-MAY-2019 | Exposing RESTful Services using APEX and ORDS | YouTube Video | Join Doug Gault from the APEX Development Team as he builds, tests and protects a set of RESTFUL services using a combination of the APEX RESTful Services Console and ORDS APIs. We’ll look at protecting rest services using OAUTH2 and an review an example PL/SQL code block that consumes the protected service.
Slides: https://www.slideshare.net/DougGault/oracle-office-hours-exposing-rest-services-with-apex-and-ords
Frist 3 Minutes - Introduction
03:06 - Brief Introduction to REST
05:18 - Brief History of REST in APEX and ORDS
08:55 - High Level Overview of the ORDS and its APIs
16:15 - ORDS Enabling an Oracle Schema
19:54 - ORDS AutoREST Description
22:45 - ORDS AutoREST Demonstration
29:03 - Manual REST Service Creation Description
32:32 - Manual REST Services Demonstration
44:20 - Securing ORDS REST Services
45:19 - Common types of Authentication
46:26 - ORDS Basic Authorization Description
49:39 - ORDS REST Basic Authorization Demonstration
53:00 - ORDS OAUTH2 Description
56:30 - ORDS OAUTH2 Demonstration
58:30 - Consuming ORDS REST from PL/SQL
60:00 - Q&A | Doug Gault | douglas.gault@oracle.com |
| 07-MAR-2019 | APEX Social Login | YouTube Video | Join Marc Sewtz and Christina Neumueller from the APEX Development Team as they discuss using Social Login with APEX.
Session Slides: https://www.slideshare.net/msewtz/oracle-apex-social-login
Video Highlights:
[2:50] Links
[5:30] Authentication
[12:15] OAuth 2.0
[23:10] Google Login
[31:20] Facebook Login
[36:50] LinkedIn Login
[43:00] Authorization
[48:00] Q & A | Marc Sewtz | marc.sewtz@oracle.com |
| 05-MAR-2019 | PL/SQL and APIs | YouTube Video | API, API, API - that's all you hear about these days (in addition to microservices, devops, etc.). APIs are critical in the distributed computing world we live in today. And they are needed at every level in the stack. Perhaps most importantly: we need solid, well-designed APIs to our data and business logic - and therein lies the strength and importance of PL/SQL. In this next Office Hours session, Steven and Chris explore how to use packages to craft excellent APIs - and invite your comments and experience on the same topic!
01:10 Types of APIs in PL/SQL (Chris presents Steven's slides because Steven is sick)
06:00 Discussions on use of TAPIs
17:52 Packages as building block for APIs
29:13 Exploring overloading
38:28 Tips for high quality APIs
44:31 Overloading and calling functions in SQL
49:21 Closing comments on key value of database APIs
With lots of interesting discussions via chat along the way! | Chris Saxon | chris.saxon@oracle.com |
| 21-FEB-2019 | Accessibility | YouTube Video | A hearing aid allowing someone to hear music for the first time; smart glasses displaying captions enabling a deaf person to enjoy the theater; a remotely assisted blind person walking an unknown busy street; glasses allowing people to perceive colors for the first time. Technology smashes through perceived barriers to participation and enjoyment, and truly enables all. This is equally true in the digital world, where, with the right approach, technology can again break through these barriers.
In this session, you will learn what the “right approach” is on the web, and how APEX can help you work toward this. Anthony Rayner, from the APEX Dev Team, will also talk about what “disability” really means; how it’s not just about those with obvious disabilities, but either through circumstance or injury, how anyone can face certain limitations or restrictions at some point in their lives, and therefore how thinking inclusively about your design and development can truly benefit everyone. Starting today, let’s all build APEX apps that anyone can use and love!
W3 Org Link: https://www.w3.org/WAI/people-use-web/abilities-barriers/
Video highlights:
[00:00] Introduction
[11:21] Common Myths about Web Accessibility
[16:16] How do we build for accessibility and what does APEX provide to help us?
[26:20] Demonstration showing accessibility testing a typical APEX application, and fixing some common accessibility problems
[55:45] Summary and Questions | Anthony Rayner | anthony.rayner@oracle.com |
| 07-FEB-2019 | APEX 19.1 New Features | YouTube Video | Join members of the APEX Development Team present on the upcoming features planned for APEX 19.1. Try the Early Adopter at https://apexea.oracle.com
Video Highlights:
[0:10] Marc - Opening Remarks / EA Announcement
[6:58] Shakeeb - Dark Mode and Universal Theme
[16:23] Carsten - Form Regions and REST read/write
[33:38] Christina - New Data Upload
[46:44] Hilary - Oracle JET Upgrade
[1:00:00] Marc - Q&A | Marc Sewtz | marc.sewtz@oracle.com |
| 24-JAN-2019 | Find Anything In Your APEX App - Fuzzy Search with Oracle Text | YouTube Video | Ever had a requirement to add fuzzy search to your APEX application ...? And did you know that Oracle Database and APEX provide everything you need?
This Application Express Office Hours session shows how to provide error-tolerant searching to your end users using Application Express and the Oracle TEXT database feature. Oracle TEXT allows to build just one Index for all your data and it provides linguistic and fuzzy search capabilities. The APEX Interactive Grid component allows to declaratively integrate such an index - however, other APEX components can leverage Oracle TEXT as well. The session shows how to build the Oracle Text index and how to use it with various APEX components. Tips and Tricks for practical usage will wrap the session up.
Slides: https://www.slideshare.net/CarstenCzarski/find-anything-in-your-apex-app-fuzzy-search-with-oracle-text
Video Highlights:
[2:50] Introduction
[8:30] Oracle Text
[11:25] APEX Interactive Grid Demo
[15:10] Oracle Text Fundamentals
[24:00] Demo - Building a new Text Index
[42:40] Summary
[44:30] Questions and Answers | Carsten Czarski | carsten.czarski@oracle.com |
| 10-JAN-2019 | Page Designer Deep Dive | YouTube Video | In this session, Patrick Wolf, Principal Member of Technical Staff within the APEX Development Team, performed an in-depth evaluation into Page Designer. His extensive demonstration shows many excellent tips and features to help you work more productively with Oracle APEX.
Key Video Timestamps:
[2:00] Demonstration
[41:30] Questions and Answers | Patrick Wolf | patrick.wolf@oracle.com |
| 15-NOV-2018 | The Value Proposition of Low-Code Development | YouTube Video | In this session, David Peake, APEX Product Manager, discussed the benefits of adopting a low-code platform to increase productivity, work collaboratively with shadow IT, and open development up to non-IT professionals.
Slides: https://www.slideshare.net/DavidPeake15/apex-low-code
Chat: http://bit.ly/apex_office_hours_chat_20181115
Key Video Timestamps:
[1:25] App Dev Conundrum
[10:55] What is Low-Code Development?
[21:55] Oracle APEX = Low Code
[25:45] Implementing a Low-Code Platform
[30:50] Q & A | David Peake | david.peake@oracle.com |
| 01-NOV-2018 | Universal Theme / Mobile Applications | YouTube Video | In this session, Shakeeb Rahman, the Design Lead for Oracle APEX, demonstrated the Universal Theme, how to create tasteful UI with APEX, and the new mobile features added to Oracle APEX 18.x Universal Theme.
Session chat transcript = http://bit.ly/apex_office_hours_chat_20181101
Key Video Timestamps:
[3:55] Mobile User Interface
[10:25] New Features in Universal Theme
[10:50] Font APEX
[16:50] Touch Support
[24:00] Floating Labels
[27:15] Template Options
[31:10] Demo
[57:40] Questions and Answers | Shakeeb Rahman | shakeeb.rahman@oracle.com |
| 18-OCT-2018 | Dynamic Actions | YouTube Video | In this beginner session, APEX Development team member Anthony Rayner, demonstrated the power of Dynamic Actions to declaratively implement client-side interactions. Rather than writing a huge amount of JavaScript, simple select when the Dynamic Action will fire, what actions it will take, and what it will act upon. He also highlighted some of the common pitfalls APEX developers should avoid when building Dynamic Actions.
Slides: https://www.slideshare.net/AnthonyRayner1/oracle-application-express-dynamic-actions
Key Video Timestamps:
[2:36] Overview
[7:50] Demo
[42:50] Bad Practices
[47:15] Future
[50:10] Question and Answer | Anthony Rayner | anthony.rayner@oracle.com |
| 04-OCT-2018 | Interactive Grid Deep Dive | YouTube Video | In this deep-dive session, APEX Product Development team member John Snyders, demonstrated the Interactive Grid. Starting with a few of the basics, John then conducted a tour of the Interactive Grid Cookbook to help you understand what is possible. | John Snyders | john.snyders@oracle.com |
| 20-SEP-2018 | Oracle Forms Modernization | YouTube Video | Watch Joel Kallman, Senior Director of Software Development, along with a number of experts from the global APEX Community, discuss Oracle Forms Modernization. Learn about the positive aspects, together with the challenges, of using Oracle APEX to modernize your Oracle Forms applications. Real-world success stories, challenges, and tips were presented. | Joel Kallman | joel.kallman@oracle.com |
| 06-SEP-2018 | Web Source Modules / REST Enabled SQL | YouTube Video | Watch Product Development team member Carsten Czarski as he demonstrates one of the most exciting new features in APEX 18.1, Web Source Modules and REST Enabled SQL.
Key Points:
32:09 - Start of REST Enabled SQL discussion.
48:50 - Start of Q & A. | Carsten Czarski | carsten.czarski@oracle.com |
| 23-AUG-2018 | Data Visualization with Oracle APEX | YouTube Video | In this session targeted at beginners, APEX Product Development team member Hilary Farrell shows the easy and impressive data visualizations possible in APEX 18.1. Questions and Answers starts at 51:30.
Slides available at: https://www.slideshare.net/secret/85bMlCoO3ts206 | Hilary Farrell | hilary.farrell@oracle.com |
| 09-AUG-2018 | Application Features | YouTube Video | n this session, APEX Product Development team member Christina Cho demonstrated Application Features, an exciting new capability in APEX 18.1! Application Features are features applicable to every application, and have been highly refined in APEX - including access control, activity monitoring, database job monitoring, user feedback, and more! Christina shows how you can rapdily build complex features with no coding, and increase your productivity in APEX 18.1.
Question and Answer starts at 40:20 | Christina Cho | christina.cho@oracle.com |
| 26-JUL-2018 | Getting Started with Oracle APEX | YouTube Video | Watch the recording of APEX Product Manager, David Peake, as he showcased how you can get started with Oracle APEX, and what problems you can solve.
Questions and Answers start at 44:10. | David Peake | david.peake@oracle.com |
| 12-JUL-2018 | APEX 18.1 New Features | YouTube Video | Watch the recording of Senior Software Development Manager Marc Sewtz as he showcased many of the exciting new features in APEX 18.1.
Questions and Answers start at 47:40. | Marc Sewtz | marc.sewtz@oracle.com |
| 28-JUN-2018 | Ask Me Anything! | YouTube Video | Oracle Application Express (APEX) is a low-code development platform that enables you to build stunning, scalable, secure apps, with world-class features, that can be deployed anywhere. We're launching our Office Hours sessions with an "Ask Me Anything", starting with an introduction to the APEX development team.
Video Bookmarks:
00:10 Introduction to APEX Office Hours series.
05:05 The APEX development team.
20:56 Questions and answers | Joel Kallman | joel.kallman@oracle.com |