jezik/language:language

Katera znanja potrebujemo, če želimo razvijati aplikacije? V primeru razvijalca, ki dela z Oracle podatkovno bazo, je osnovo znanje SQL in PL/SQL jezika. SQL in PL/SQL potem lahko uporabimo v Oracle razvojnih okoljih, kot sta npr. Oracle Forms ali Oracle Application Express. Vendar, ali je to dovolj? Kaj pa podatkovni model, razvojna orodja, upravljanje izvorne kode, integracija z drugimi sistemi, ali poznamo novosti nove verzije baze, kakšne so usmeritve za prihodnje verzije,...?

Predavanja v tem tematskem sklopu ponujajo odgovore na vsa ta vprašanja in tako zajemajo zgodbo razvojnega procesa, od modeliranja podatkovnega modela pa do vizualizacije podatkov.

 

Vrstni red predavanj je urejen po alfabetičnem vrstnem redu naslovov predavanj.

 

A Deep Dive into APEX JET Charts

Roel Hartman
engRoel Hartman
APEX Consultingace director

 

Abstract

In this session we will take a closer look on the options the new JET Charting engine brings to the APEX world. There are a quite a lot of declarative options to explore, but also the JavaScript API is worthwhile to investigate.

You will learn that with just a few lines of JavaScript you can change the look and feel of a chart to your own needs.

Application Express 5.1 and beyond ...

Carsten Czarski
engCarsten Czarski
ORACLE Deutschland B.V. & Co KG

 

Abstract

Application Express 5.1 is available since December 2016. Many users have already installed this new version which not only provides the new Interactive Grid or Oracle JET charts.

This presentation gives on overview on APEX 5.1 also highlighting the smaller features, which not everybody talks about. Beyond that the session will give a brief outlook on what's coming with future APEX releases.

Application Express and the REST of the world - Part 1,2

Carsten Czarski
engCarsten Czarski
ORACLE Deutschland B.V. & Co KG

 

Abstract

Learn how to access REST services from within Application Express. The presentation will show, how to invoke a REST Service, how to process JSON or XML responses and how to build reports or charts on top of this. Finally, attendees will get an outlook on future trends regarding APEX and REST.

In the old days, things were simple: Data was in the (Oracle) database and APEX applications worked with that data. But today, we have to integrate data from different sources all the time. These data sources can be on the internal network, but also on the internet.

Today, the REST architecture is commonly used to interface between different systems: REST services are often provided, so we want to use these REST services with the Oracle Database and APEX applications. The presentation will give a brief introduction to REST, cover the building blocks to invoke REST Services and to process the response and finally put everything together in Application Express.

Design your databases straight to the Cloud

Heli Helskyaho
engHeli Helskyaho
Miracle Finland Oyace director
Elise Valin Raki
Elise Valin-Raki
Fenniaace director

 

Abstract

Everybody is talking about Cloud. How does the Cloud change my work as a database designer? What should I know and what new to learn?

In this session we will talk about these concerns and design a small database to the cloud using Oracle SQL Developer Data Modeler and Oracle SQL Developer.

Docker for Dummies

Roel Hartman
engRoel Hartman
APEX Consultingace director

 

Abstract

You might (or might not) have heard of Docker. But you have no idea what it is and why you should care. But if you are a database or APEX developer and still work with Virtual Machines, it is about time to broaden your horizon.

In this session you'll learn what Docker is and how you can benefit from it in your daily work.

From 0 to APEX - APEXify your Newbies

Dietmar Gabauer

 

Abstract

Experienced APEX developers are rare on the market - let's educate some! This presentation gives an overview, how FOEX enlarged the development team.

What is APEX? What's needed in addition? SQL, PL/SQL, HTML, CSS, JavaScript......what else? How can this be trained? How do I phase-in a new, basic trained employees into running project work? Answers to these questions are out of our experience in phasing in new employees and employees having different knowledge.

Function Result Cache - Fixed.

 

Abstract

On troubleshooting a particularly Complicated PL/SQL-based system, a so-called thick-db system, we found that the Function-Result-Cache did not work as advertised. A Colleague found the cause, and devised an inventive Fix.

This presentation is must for developers struggling with over-complicated systems, and for the architects that design them. We can help you avoid some Mistakes.

Histograms are Evil like Chocolate is Evil

Neil Chandler
engNeil Chandler
Chandler Systemsace director

 

Abstract

Continuous Delivery is a topic that can become very complex in big environments - but starting with this subject is not that difficult as many may think.

Are you using Histograms? Yes, of course you are - even if you didn't know it. Did you want to use them? Are they helping you get to the optimal optimization plan, or making life harder for the optimizer? I will explain the benefits and threats associated with histograms, how the new 12.2 histogram types make them more acceptable, where they are still a threat and how I usually handle them for greatest benefit in large systems.

How to build the perfect dashboard

Pavel Glebov
engPavel Glebov
FRT Consulting GmbH

 

Abstract

Dashboards have become a standard business and operations tools. Unfortunately, many of them are overloaded and difficult in daily use.

This presentation covers high-level know-how to build focused, thoughtful, and user-friendly dashboards. Namely it includes base principles and graphical design, explanation of practical usage of APEX components, Charts, JET-technology, and Plugins. Also the approaches to modify Oracle DB, using both well-known and newest 12C features, to get answer almost in real-time are described.

Izgradnja modernih aplikacij z uporabo API, mikrostoritev in klepetalnih robotov

Toma Potuvan
engTomaž Poštuvan
Oracle Software d.o.o.

 

Abstract

Časi, ko se je razvoj programske opreme štel v mesecih, pisanje popravkov pa v tednih, so minili. Nove verzije aplikacij se razvijajo in nameščajo večkrat na dan, včasih celo večkrat na uro. Arhitekturne zasnove teh aplikacij niso več monolitne, temveč temeljijo na mikrostoritvah ter enostavnih protokolih za komunikacijo med njimi. Razvijalci razvijajo moderne aplikacije, ki so dostopne uporabnikom preko različnih kanalov. Normalno je, da se uporabniška izkušnja ne menja, če namesto klasičnih računalnikov uporabimo kar svojo mobilno napravo, bodisi tablico bodisi kar pametni telefon.

Pristop »Najprej API« (API first), kjer najprej razvijemo programski vmesnik API, šele nato pa nad njim aplikacijo, postaja vedno bolj dominanten. Istočasno je tudi kritičen, saj združuje med seboj vse komponente sistema ter omogoča, da aplikacije, razvite za oblak (»Cloud native«), lažje dostopajo do podatkov in procesov. Služi tudi kot način komunikacije med razvijalci zalednih (back end) in čelnih (front end) aplikacij.

V predstavitvi si bomo ogledali, kako moderne aplikacijske platforme omogočajo razvijalcem, da enostavno gradijo ter povezujejo spletne ali mobilne aplikacije, le-te pa uporabljamo na različnih napravah."

Kreiranje Word docx dokumentov iz podatkovne baze

Zoran Tica
sloZoran Tica
ZT-TECH

 

Abstract

V predavanju bom predstavil metodo kreiranja Microsoft Word docx dokumentov neposredno iz podatkovne baze z uporabo PL/SQL package-a, katerega sem razvil za potrebe mojih projektov. Najprej bom razložil način izvedbe in delovanje programske logike, potem pa uporabo na konkretnih primerih. Kreiranje dokumentov neposredno iz podatkovne baze se je pogosto izkazalo kot zelo uporabno, ker za samo izvedbo niso potrebna nobena dodatna zunanja orodja ali tehnologije, LE PL/SQL znotraj podatkovne baze.

One click to rule them all - Continuous Delivery for everyone in 45 minutes

Christian Klingbacher
engChristian Klingbacher
Altran Concept Tech GmbH

 

Abstract

Continuous Delivery is a topic that can become very complex in big environments - but starting with this subject is not that difficult as many may think.

The purpose of this presentation is to show, how fast and easy APEX Applications can be deployed automatically to different environments with only one click. Using Git, Apache Maven, and Atlassians´ Bitbucket, it will be demonstrated how to setup and run a complete deployment pipeline by the creation of only two text files. Furthermore, it will be shown how any Docker image can be used and configured as basis for the deployment process.

Until the end of the presentation the attendees will receive a comprehensive step-by-step description of how to introduce and maintain their own Continuous Delivery for their APEX applications.

Oracle 12c for Developers

Alex Nuijten
engAlex Nuijten
all APEXace director

 

Abstract

Do you want to get up to speed with the most current release of the Oracle database? Then this session is for you.

You will learn the most exciting and most useful new features from the Oracle Database 12c which can make your work as database developer a lot easier. There is more to the Oracle database 12c than just pluggable databases.

Pimp my grid

Marko Goriki
engMarko Gorički
BiLog d.o.o.

 

Abstract

We all waited a long time for "the grid" feature. Now when it's finally there it's time to use it in your projects. Is it ready for this?!

In this presentation I'll talk about my experience with the first project where I've used Interactive grid and I'll try to dig a bit deeper to show you some of the advanced features.

Regular Expressions: Say What?

Alex Nuijten
engAlex Nuijten
all APEXace director

 

Abstract

It has been possible since Oracle database release 10, Regular Expression support with its own set of functions. But getting started with Regular Expressions is not easy. Most database developers would avoid them if at all possible. With current release of the Oracle database, Regular Expression syntax becomes more important. You can use them to redact data with DBMS_REDACT and to search for patterns using the Match_Recognize clause.

This session covers the basic syntax and gives you an easy introduction with Regular Expressions with plenty of code samples.

Top 10 Features of Oracle SQL Developer everybody should use, even in the Cloud

Heli Helskyaho
engHeli Helskyaho
Miracle Finland Oyace director
Elise Valin Raki
Elise Valin-Raki
Fenniaace director

 

Abstract

Oracle SQL Developer is a tool every Oracle user should be using. In Oracle SQL Developer there are excellent features that will make your life easier, does not matter if you are a dba, a developer or a database designer.

There is plenty of great features for everybody, Learn about my favourite features that will hopefully make your life easier too and make you a more profitable member of your IT team.

All the demos in this session are performed in the Oracle Cloud.

Utilizing the data attribute: Client-side behavior in APEX

Richard Martens
engRichard Martens
Smart4solutions BVace director

 

Abstract

Creating an APEX application is easy, just follow the wizards to create all those reports and forms. But what if you want to add some client functionality like deleting a record using a form, or do some 'drag-n-drop' ordering of records.

The presentation will show you how to add client side and AJAX functionality to your apps.