Agenda

Tudi prejšnje leto smo imeli virtualno konferenco, ki se je odvijala čez cel teden, zato smo jo poimenovali MakeIT Week. Letos smo se odločili za drugačen format. Namesto dveh dni z več vzporednimi predavanji, bomo imeli več enodnevnih ali dvodnevnih dogodkov. Vsi ti dogodki bodo v jeseni, zato ime MakeIT Autumn.

The Good thing is that Oracle APEX is secure out of the box but....

Some of the main reasons why attacks on web applications are successful are due to an insufficient level of security, and the lack of a security focus when developing applications.

This talk is a story about a guardian (aka APEX developer), who is doing his best to secure every door, and the damages caused by a data thief when he finds some back doors unlocked.

The presentation gives you an opportunity to learn how your APEX applications can be vulnerable to attacks and the simple steps you can take to protect your APEX estate from mischievous employees or dedicated external hackers.

Organizations who fail to secure their web applications run the risk of being attacked. A data breach can result in serious consequences in relation to reputation, finances and even regulatory failures.

Web application vulnerabilities are typically the result of a lack of input/output sanitization, which are often exploited to either manipulate source code or gain unauthorized access.

APEX applications aren't an exception and developers should all adequately be addressing this.

This talk is a primer for every APEX developer interested in learning

• the common vulnerabilities faced by APEX applications, including SQL injection, Cross-site scripting, and URL tampering

• how to perform the application security scanning

• available tools (APEXSec, APEX-Sert, APEX Advisor) one can use to detect security issues

• what can actually happen when a security vulnerability remains open

• tips to improve the security of APEX applications

Author's biography

Mirela started developing in PL/SQL and Oracle Forms back in 2000 and she is currently working as an APEX and PL/SQL developer for a consultancy company.

She is co-founder and Vice-President of Romanian Oracle User Group, board member of EOUC e.V., meetup organizer, lecturer for students enrolled in Oracle Academy program, part of the team who innitiate the Mentor and Speaker Hub Program.

Mirela is the first person from Romania accepted in Oracle ACE Program.

When we create our programs, we usually don’t anticipate anything will go wrong. And it won’t, during development and testing. But in production there is always someone who does something unexpected and your code fails. When running in dev you can easily step through your code and see what happens, but in production you are not allowed to do this. How great would it be that you could see what was happening in the production environment? But logging every step takes up a lot of the performance. Installing debuggable code in production just to see what’s going on is usually a no-go. By instrumenting your code you can get the information you need by ‘flipping a switch’. This session shows how you can use the (extended) Open Source Logger framework to accomplish this.

Author's biography

Patrick Barel is a PL/SQL Developer for Qualogy [http://www.qualogy.com/] in the Netherlands. Besides working with SQL and PL/SQL he wrote different plug-ins [http://plugins.bar-solutions.com/] for PL/SQL Developer [http://www.allroundautomations.com/]. He publishes articles on his own blog [http://blog.bar-solutions.com/].

In 2015 he received the Oracle Developer Choice Award in the PL/SQL Category.

In 2019 he was promoted to Oracle ACE Director [https://apexapps.oracle.com/pls/apex/f?p=119297:3:::::SEARCH:Patrick%20Barel]

APEX 21.1 introduces lots of cool new features you should know about:

• new Maps component

• Oracle Multilingual Engine (MLS)

• Application Data Loading

• support for Calendars and Maps with Faceted Search

• or improvements on Card regions

In this session, we will present and demonstrate the key features of APEX 21.x release and practical tips for using APEX in daily practice.

Author's biography

Oracle APEX consultant with 15+ years of experience. Consulted for APEX R&D, Skillbuilders team and most recently fab.earth. Worked with clients in Europe, USA, Asia, Australia and New Zealand across all sectors. AUSOUG Connect APEX content chair, webinar organizer, speaker at KSCOPE, APEX world, APEX Connect, APEX ALPE Adria, AUSOUG & APAC groundbreakers conferences. APEX blogger and Oracle ACE.

During the night, Back-office systems have to process tons of records and calculate millions of values. Systems usually are very busy during the night. But is the night long enough to do such hard work? The end of day processes in the back-office systems can take several hours. Record holders are approaching even 24 hours!

In the session, I will discuss a successful system re-engineering project that involved gathering information on the current system and analyzing requirements, and transforming them into the system of tomorrow. I will walk through the main process I went through: the requirements, design, and PL/SQL code, and the changes that allowed us to shorten the processing time. Not only did we improve a single process but the entire system processing time was reduced from several hours to several minutes.

Come to this session and find out what were the key factors to achieving success!

Author's biography

Monika is an experienced Oracle architect, designer, and developer. She has started her journey with Oracle in the last century with Oracle DB 7, continues to this day. She emphasizes the solution's simplicity, code quality, best practices, and above all - system performance.

She is an Oracle Ace Associate and willingly shares her experience.

She loves fast motorcycles and databases!

Now that APEX 20.1 is not a new thing anymore when it comes to printing or exporting data from your applications we still encounter the same challenges -> How do we print in APEX?

What is the best tool for the job? Are there any freeware software that we can use? How to decide which one to go with especially if you are new to Oracle Application express?

We all asked ourselves this on a regular basis and in this presentation we will go through some available options that are on the market and how to integrate them with APEX.

After all we have to be up to date with new and upcoming technologies that can make our lives as developers a bit easier.

Some of the print engines we will see in action JASPER, BI Publisher and AOP.

Author's biography

Oracle APEX consultant with 15+ years of experience. Consulted for APEX R&D, Skillbuilders team and most recently fab.earth. Worked with clients in Europe, USA, Asia, Australia and New Zealand across all sectors. AUSOUG Connect APEX content chair, webinar organizer, speaker at KSCOPE, APEX world, APEX Connect, APEX ALPE Adria, AUSOUG & APAC groundbreakers conferences. APEX blogger and Oracle ACE.

Learn about what's new in Oracle Database 21c for Database development. Oracle Database 21c is packed with many innovative new features from Blockchain Tables and Native JSON support, but have you heard about any of the SQL and PLSQL innovations? Attend this session to learn more about what your missing.

Author's biography

Sean Stacey is an Outbound Product Manager at Oracle with over 20 years specializing in the Oracle Database. He frequently provides technical advisory services and education to Oracle customers and partners. Sean has authored several white papers and blog articles and frequently speaks at Oracle user conferences.

Prior to joining Oracle, Sean was a software developer and then an Oracle Database Administrator in Australia, the United Kingdom as well as the United States. He currently resides in Raleigh, North Carolina.