Tag: Application Express

Presented at INSYNC 21

Session ID: 101990

This workshop starts with a napkin design of data structures we would like to use for a proof-of-concept. Using Quick SQL you will quickly define the data structures and utilize various table and column directives to better define the tables and also create some dummy data. You will then be creating an application based on the new tables. Lastly, you will be updating some of the generated components to improve the initial app.

INSYNC is taking place March 30 - April 1, 2021! This brand new, deep-dive virtual conference is exclusively for Database and Technology users, and INSYNC registration is open now!

INSYNC 21​ is jam-packed with Oracle Database and Technology learning​ - focusing on topics like DevOps & Deploy, Database, Data Science & Analytics, and Professional Development.

This virtual conference connects DBAs to product experts, industry innovators, technology leaders, and Oracle product teams for three full days of online education and networking. Get hands-on with the experts, dive into demo’s and workshops, connect with other Oracle database users, and meet solutions providers – all from the comfort of your desk.

Presented at Quest Experience Week (QXW) – Database & Technology Day

The need for immediate applications to manage information has never been greater. Within the past year, countless organizations around the world had unanticipated requirements thrust upon them. Those organizations skilled in Low Code development platforms delivered solutions far faster than their traditional coding counterparts. Learn what their advantage was. This session will be a live demonstration of Oracle Application Express (APEX), the low code development platform from Oracle. In a matter of minutes, we will go from concept to data model to prototype to refined application. We’ll also convert a spreadsheet to a multi-user Web application. Two applications in under 45 minutes. Fasten your seat belt!

Presented at Quest Experience Week (QXW) – Database & Technology Day

At Oracle OpenWorld 2019, Oracle announced an Always Free Tier of cloud services. This session will review what’s available with these free cloud services such as Oracle autonomous databases including Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP), compute with up to 2 virtual machines, storage including block, object, and archive storage. We’ll explore how these free services work and what can be done with them, such as creating proof of concept systems. Looking for data? No problem! We’ll explore the vast number of free data sources that are available and can be consumed using Application Programming Interfaces (APIs). Once we combine the two, we can easily pull data into these cloud services while creating fully functioning applications including the use of Oracle Application Express (APEX).

Quest Forum Digital Event 2020

Oracle now boasts two Low Code development tools for building new applications or extending your Cloud services:  Application Express (APEX) and Visual Builder Cloud Service (VBCS).  How do they measure up? Which is right for your organization?  Do they work together? Which is best, for which use cases?

This session presents APEX and VBCS side by side, using a simple common application to illustrate the talking points. 

Attendees will learn essential information for making an informed decision on which to use – or both. The session covers key features of each for development, deployment, costs, learning curve, usability, and time to master. For those who have not seen APEX or VBCS, or want to see the side by side comparison, here you go. Attendees will gain information to assess which cloud development tool is best for their business needs.

Quest Forum Digital Event 2020

In this session, Blaine Carter will demonstrate how to REST enable your database using Oracle Rest Data Services (ORDS). He will demonstrate how to use SQL Developer to create and deploy REST services in ORDS. First, Blaine will "Auto Rest" enable a table and a PL/SQL package. Then, he will secure the API and create an OAuth2 client that can be used to access the service. Next, he will walk through the steps of creating a custom REST API using the REST Data Services wizard. This API will be used to POST image files into a BLOB column in the database and the GET handler will serve the image directly in a web page. You will leave this session with an understanding of how to quickly create REST services on your own database.

Quest Forum Digital Event 2020

ChatOps is an automation model connecting users and tools to processes through messaging applications. It leverages the simplicity and familiarity of chat to empower users to interact directly with applications and databases, retrieving information, and performing work in real-time. Done right, ChatOps is a safe, agile way to minimize or eliminate tedious, repetitive operational tasks and reduce workloads. Virtually anything can be automated or called via ChatOps through simple commands—from self-service password resets, to initiating reporting cycles, to running ad hoc refreshes of development environments—all without granting end users access to a database or application.

This session covers:
-Connecting Oracle databases in the Cloud or on-premises to chat services via REST
-Considerations for building database APIs to handle ChatOps interactions
-Methods for securing communications between the database and application
-Practical examples of ChatOps integrations

Quest Forum Digital Event 2020

Want to learn about Git? If you are thinking about using a Version Control System, this is a session you must attend, also this is a must-have skill for DBAs, Developers and Product Managers! Learn how we implemented this type of technology at CloudDB and how we are been beneficiate by it!

Learn all about Git and Oracle Developer Cloud Services and how to Streamline Team Development and Software Delivery using a SaaS solution.

You will be able to plan and manage: Issue tracking, Team management, Agile Dashboard.

With regards to code: Version management, code review, and track changes.

Plus build and deliver (continuous integration, orchestration, deployment automation) and finally team collaboration (activity stream, wiki, web dashboard).

Quest Forum Digital Event 2020

APEX Interactive Grids have a myriad of customization options, some declarative, and most via JavaScript APIs.  How to stay sane, organized, and consistent with so many options? Standardize!  Delivering clean, uniform, customized interactive grids within a single application, or across many developers, many applications across an organization is less difficult than you think.

We will demonstrate use of a common configuration file and classes to standardize grid features across your applications. Decide upon your grid options, code them once, then include and use everywhere. Better yet, not everyone needs to be a JavaScript expert to implement your standard grid configurations. Attend to learn how to standardize grid customization, and save on sanity.

Quest Forum Digital Event 2020

The majority of modern IT solutions consist of multiple systems communicating using APIs. The “common language” is usually JSON. Unfortunately, the Oracle RDBMS did not have native JSON support until version 12c. Previously, developers had to use either third-party tools (the most popular was PL/JSON) or write their own code to support JSON processing. When it comes to database upgrades, the question arises: Should we utilize new features or not? This question is especially relevant when you need to edit 10,000+ lines of code and core system functionality.  The authors decided to accept a challenge and migrate from PL/JSON to Oracle native JSON and share their story with conference attendees.